Split Data from Column to Multiple Columns

[ArijitRoy]

Hello Friends,

I have attached a sample file. In the first column, I have data on 30 rows. I want to divide them into 3 columns, which means 10 rows for each column.

It should be dynamic as I have more than 1M data on the first column and want to divide them and each column should have 9000 rows. 

Every column should have only 9000 rows data.

[Luke_C · Accepted solution]

Hi @ArijitRoy 

Have you looked at the make columns tool? It lets you enter how many columns you want. It is limited at 1000 columns, though. 

[ArijitRoy]

Hi @Luke_C,

This is a great tool but not dynamic. I want to fix per column data to 9000 rows.

[Luke_C]

Hi @ArijitRoy 

Here's a bit more dynamic. Update the first multi-row formula from 10 to 9000 and you should be good to go.

[ArijitRoy]

Hi @Luke_C ,

Just look at the last column. Why we have blanks in middle of the rows? Last column should not have any blanks in middle.

[ArijitRoy]

Thanks @Luke_C for the tool. I have used sort tool on the Counter column.

[binuacs]

@ArijitRoy 

[Luke_C]

Hi @ArijitRoy In my example there is a null because you only provided 29 rows of actual data (30 including header).