I have Excel data in the below format:
Excel Std Row: A B C D E F G H I J
1st Row Data: 1 1 2 2 4 4 5 5 6 6
Now I need output as below:
A B
1 1
2 2
4 4
5 5
6 6
Can someone tell me how to use the "Transpose" function in this case?
Note: A, B, C, are standard Excel column alphabets & not user defined column.