one excel sheet into two different output files

[timoyd]

Hello Everyone,

Is it possible for me to have two different output files from one input data? I have an excel sheet that i need to sort by type and have separate sheets or files by it's type.

I need to separate all the "STO" in column E into a different sheet or file.

[szade1]

Hi @timoyd ,

Yes, you can create two different output sheets from one input data.

Use the combination of Layout and render and group by "Type". In Layout, use the option "Vertical with Section Breaks" in orientation

I have attached the workflow for your reference.

Hope it helps.

[grazitti_sapna · Accepted solution]

Hi @timoyd , there are different ways to solve your problem I have mentioned the 4 of them depending upon the requirement.Please have a look and let me know if you have any other requirement.

Thanks.

First 2 methods will provide you files and tabs bases on types available and the other two will categorize the types in STO and others and will provide you 2 files or tabs. In case of csv you will get separate files and for xlsx you will get tabs.

I hope this helps.

Thanks.