How to export the different excels and different sheets base on different columns

Have a large target data and want to export it to different excel by column 1 and then split it into different tables by column 2, how to do it?

Datasets

Output

Accepted answers

Robin_McIntosh

Here's an example for the first part of your ask, separate Excel file based on column value. Not sure exactly what you mean for the second part of your ask.

Discussion_Separate_Excel_Based_on_Column.yxmd

All comments

binu_acs

@Zhiting would you be able to provide a sample input file and the expected result?

Robin_McIntosh

Here's an example for the first part of your ask, separate Excel file based on column value. Not sure exactly what you mean for the second part of your ask.

Discussion_Separate_Excel_Based_on_Column.yxmd

Zhiting

Hi Robin, thanks. Second part is to split it base on the another column: Equipment.

Here is the example for the separate excel: Department, And how to split into different Equipmen as sheet?

Robin_McIntosh

Basedon your second piece, here's the updated workflow example.

Discussion_Separate_Excel_Based_on_Column.yxmd

Zhiting

Thanks !

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335