Split data as separate tables

[SahadhKuruniyan]

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

[binuacs]

@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

[Luke_C]

Hi @SahadhKuruniyan 

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?

[Qiu]

@SahadhKuruniyan 
Since you mentioned that you want to split data as separate tables, which I assume diffirent Excel Sheets.

[SahadhKuruniyan]

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.

[Luke_C]

Hi @SahadhKuruniyan 

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. 

[SahadhKuruniyan]

Thanks mate!

I want the data you be in a single tab. Is that possible

[SahadhKuruniyan]

Hi @Luke_C 

I want the the data get splitted as tables in a single excel tab

[SahadhKuruniyan]

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