Dynamic Filter based on data

Question

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.

Input Data.xlsx

Expected Output.xlsx

Bren_Spill2 · Accepted Answer

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

Raj · Accepted Answer

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

you can take sheet names from a column.