Split numbers in one column to multiple columns

[sharshra]

I have a list of numbers in one column. I would like to split it into multiple columns having certain number of rows. I searched internet but couldn´t find a satisfactory answer. Can the experts in this forum help?

Consider the following example. Source table has a list of 10 numbers. I want to split these 10 numbers into multiple columns with each column having 3 rows.

Number of rows in the source table & the split tables can vary. For example, source table may have 5000 rows & needs to be split into multiple columns, each having not more than 15 rows.

Source table:

excel problems.xlsx
	C
2	23
3	67
4	98
5	64
6	72
7	199
8	59
9	44
10	102
11	2
Sheet4

Desired output:

excel problems.xlsx
	E	F	G	H
2	23	64	59	2
3	67	72	44
4	98	199	102
Sheet4

 

[Fluff]

What determines how many rows/columns you end up with?

 

[ISY]

Hi

=WRAPCOLS(A2:A11,3,"")

 

[sharshra]

Thanks, @ISY.