Row to Column

[manojkulkarni]

Hi All,

I am having data in below format, would like to convert into Columns. Please suggest how to acheive.

User ID	Segment	Bills
1	Seg1	12
1	Seg2	13
2	Seg1	15
2	Seg2	12
3	Seg1	11
3	Seg3	12
4	Seg1	16
4	Seg2	12
4	Seg3	10

expected result :

User ID	Seg1	Seg2	Seg3	Seg4
1	12	13
2	15	12
3	11		12
4	16	12	10

[marcus_sommer · Accepted solution]

Have a look here: The Generic Load

- Marcus

[Mark_Little]

Hi,

I was going to suggest looking at the cross table option. But I think Marcus's option is better.

Also like to thank Marcus for pointing it out and the good blog post by Henric.

Mark

[neha_sri]

Hi Manoj,

Please use below script.

Generic  LOAD [User ID],
     Segment,
     Bills
FROM

(ooxml, embedded labels, table is Sheet7);

[manojkulkarni]

Thanks Marcus. It worked

[manojkulkarni]

Thanks for your suggestion