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

[Zhiting]

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?

[binuacs]

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

[Robin_McIntosh · Accepted solution]

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.

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

[Zhiting]

Thanks !