Hello,
I have a data like below and I have to split these as separate column based on data in column 1:
Number | Account |
1A | 454 |
1A | 434 |
1A | 545 |
1A | 765 |
2c | -155.9 |
2c | -257.4 |
2c | -358.9 |
2c | -460.4 |
3D | -561.9 |
3D | -663.4 |
3D | -967.9 |
3D | -1069.4 |
Output should look like this:
Number | Account |
1A | 454 |
1A | 434 |
1A | 545 |
1A | 765 |
Number | Account |
2c | -155.9 |
2c | -257.4 |
2c | -358.9 |
2c | -460.4 |
Number | Account |
3D | -561.9 |
3D | -663.4 |
3D | -967.9 |
3D | -1069.4 |
If any one could hep me here that would be a biggest help
@SahadhKuruniyan One way of doing this with the help of Tile tool. Select the unique value option and unique column as Number. Later you can filter out the tile output based on the Tile_Num field
If you're outputting to excel you could put them on different tabs by configuring the output tool to do so. I think it depends on what exactly you're looking for, are you looking to process the data differently in the workflow based on the number value? Or simply output into distinct tables?
@SahadhKuruniyan
Since you mentioned that you want to split data as separate tables, which I assume diffirent Excel Sheets.
Thanks for sharing you knowledge.
But the thing here is ,the number of accounts in column 1 will be added or reduced.
For eg, in above example we have 3 accounts 1A,2C and 3D but that will change.
Can you share exactly what you're looking for? The 3 solutions provided should work regardless of the number of accounts in the first column.
Thanks mate!
I want the data you be in a single tab. Is that possible
Thanks @binuacs ,
In this case I don't have to add a tile tool as first coloumn is already a unique id, so I can filter using it