How do I pivot distinct values in Excel PivotTable fields editor?

Question

I have a table layout with different number of text values for each id column. Now, I'd like to pivot them, so that each id gets a single row and each text value is put into a different column of the id row:

How can I do that using PivotTable Fields editor?

Answer 1

select * from Sheet1 limit 20;

select f01,group_concat(f02,'</td><td>') text from Sheet1 group by 1;