Forum Discussion
fakewen
Apr 24, 2023Copper Contributor
What's the easiest way to split a list into a specific number of rows and columns?
For example I have a column with the numbers 1-20, and I want to split it into 3 rows by 4 columns, then the reminder of the rows with 3 columns, while maintaining a horizontal order: 1 2 3 ...
Lorenzo
May 14, 2023Silver Contributor
=IFNA(
VSTACK(
WRAPROWS(TAKE(A1:A20,12),4),
WRAPROWS(DROP(A1:A20,12),3)
),
""
)