Currently, I have data in the form of two columns:
A 1
B 2
C 3
D 4
A 5
C 6
D 7
A 8
B 9
D 10
etc, in repeated sections such that the data in the first section (1 2 3 4) are together, the second section (5 6 7) are together and so forth.
I want to convert it into the form of
A B C D
1 2 3 4
5 6 7
8 9 10
Such that the data in each section are put into the same column (e.g. 1,5,8 under column A; 2,9 under column B; 3,6 under column C; 4,7,10 under column D)
Thanks!
central227
Bookmarks