Forum Discussion
mwin1680
Nov 14, 2022Copper Contributor
One column into multiple columns
I have one long column (2000+ rows) of numerical data which needs to be converted to multiple columns of 50 rows each. i.e 32 24 53 352 42 5 26 34 43 to this ...
- Nov 14, 2022
Presuming numbers in A1:A9
1st option:
=WRAPCOLS(A1:A9,3)
If WRAPCOLS is not available:
=INDEX(A1:A9,TRANSPOSE(SEQUENCE(3,3,1,1)))
Patrick2788
Nov 14, 2022Silver Contributor
Presuming numbers in A1:A9
1st option:
=WRAPCOLS(A1:A9,3)
If WRAPCOLS is not available:
=INDEX(A1:A9,TRANSPOSE(SEQUENCE(3,3,1,1)))