Forum Discussion

mwin1680's avatar
mwin1680
Copper Contributor
Nov 14, 2022
Solved

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 ...
  • Patrick2788's avatar
    Nov 14, 2022

    mwin1680

    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)))

     

Resources