Divide data in table as separate tables based on a unique id

[SahadhKuruniyan]

Hi Team,

I am working on a project. I am a beginner. Can anyone help me with my query below:

I have a excel tab which as a list(See tab "Current output" in attached file). now I want to split this table as  separate tables in a single tab (want tables in single tab as output) based on a unique number in coloumn A.

Can any one please help. this would be biggest help :)

[Qiu]

@SahadhKuruniyan 
This can be done by providing a fulll path for the output including the Tab name

[binuacs]

@SahadhKuruniyan Based on my understanding I think you are looking for the column in same tab, in that case you can use the Table tool to group the fields based on the unique number.

[binuacs]

@SahadhKuruniyan Another way of doing this with the batch macro

[grazitti_sapna · Accepted solution]

@SahadhKuruniyan, as @binuacs suggested this can be achieved using reporting tools. Below is the configuration that I used along with the output.

You can change the output mode as per your requirement.

Thanks!