Split Data from Column to Multiple Columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Designer Cloud
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Luke_C for the tool. I have used sort tool on the Counter column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ArijitRoy In my example there is a null because you only provided 29 rows of actual data (30 including header).
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)