Forum Discussion

bofus's avatar
bofus
Copper Contributor
Dec 02, 2022

colum split

I have a single column of 70K plus entries that I want to split into multiple columns of about 50 each. Any suggestions?
excel
dscheikey's avatar
dscheikey
Bronze Contributor
Dec 02, 2022

bofus 

Three possibilities with formulas:

 

=TRANSPOSE(INDEX(A2:A70001,SEQUENCE(ROUNDUP(70000/50,0),50)))

=WRAPCOLS(A2:A70001,50)

=MAKEARRAY(50,ROUNDUP(70000/50,0),LAMBDA(a,b,INDEX(A2:A70001,a+((b-1)*50))))

 

WRAPCOLS() is only available for Excel Insiders.

Resources