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.
Solved! Go to 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.
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.
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.
Thanks @Luke_C for the tool. I have used sort tool on the Counter column.
Hi @ArijitRoy In my example there is a null because you only provided 29 rows of actual data (30 including header).