Dynamic Filter based on data

[Dhilip_Kumar]

Hi,

I want to filter out each Product types and make those as separate tab, Product types would be dynamic unable to determine the number of types sometimes it would be 5 types sometimes it would be 15. So how could I filter those types and save it as a sperate tab in output.

I have attached my Input data and expected output result for your reference. Please have a look at it and advise me.

[Bren_Spill · Accepted solution]

@Dhilip_Kumar - you can use functionality of the Output tool to do this - see attached.

[Raj · Accepted solution]

@Dhilip_Kumar  You can use Output tool Capability to achieve this,

you can take sheet names from a column.

[Dhilip_Kumar]

Thank you so much @Bren_Spill @Raj. It is working perfectly.

[Bren_Spill]

No problem @Dhilip_Kumar. Can you mark both of our responses as solutions? Thanks!