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

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

Sample.xlsx

Workflow

Accepted answers

grazitti_sapna

@SahadhKuruniyan, as @binu_acs 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!

SahadhKuruniyan_workflow.yxmd

All comments

Qiu

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

0515-SahadhKuruniyan.yxmd

binu_acs

@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.

separate_tables_15_05.yxmd

binu_acs

@SahadhKuruniyan Another way of doing this with the batch macro

separate_tables_15_05.yxzp

grazitti_sapna

@SahadhKuruniyan, as @binu_acs 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!

SahadhKuruniyan_workflow.yxmd

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335