Output in same excel file different sheet with use case of Sumamrize

[Navya08]

Hi

i have a dataset as attached can someone help me to reach out to desired output as shown in img 2 as attached. In same excel workbook but different sheets.

i want one workflow for all three use case

thank you in advance.

[Qiu]

@Navya08 
You can define the Full Path for the output and use the option below

[Navya08]

Can you please share the sample workflow for output 1 and three as well? Please if possible 

[Qiu]

@Navya08 
Please share some sample data.

[Navya08]

This is the data sample

[Qiu]

@Navya08 
I meant data, not picture...🙄

[Navya08]

i apologise.😅

[Navya08]

@Qiu is it fine ?

[Raj]

@Navya08 Do the required transformation as per requirement and the last step to write in multiple sheets is added below for reference.

let us know if you are looking for something else.

[Navya08]

Thank you for the help.

i have got the way to get the excel output in one workbook 

i need a workflow for transformation only. As shown in ss 2. Having three outputs in three diff sheets.

in short, i want to see the sample workflow for this use case with the output attached