Hi All
I have the following Excel file
QQ COL1 COL2
q1 1 45
q1 2 45
q1 3 45
q1 4 4234
q2 10 2
q2 20 12
q2 30 3
q2 40 5
I want to transpose the columns in the following order, grouped by QQ field. So I need the following result:
q1 q2
col1 col2 col1 col2
1 45 10 2
2 45 20 12
3 45 30 3
4 4234 40 5
How can I obtain such result?
Bookmarks