How to read multiple sheets from Excel file as separate columns in output file

[ToxicBuoy]

Hi,

I have a use case where I need to read separate sheets from Excel file to an output file but the data from each sheet as a separate column with sheet name as header name. Also the number of sheets gets added each week.

Attached sample for reference.

[Qiu · Accepted solution]

@ToxicBuoy 

This should work for your use case.

[ToxicBuoy]

Thanks @Qiu . However I am unable to open the package since I am using a lower ver.. Could you xplain what you did on cross tab tool?

[Qiu]

@ToxicBuoy 

Here

[ToxicBuoy]

Thanks @Qiu , thats perfectly works

[Qiu]

@ToxicBuoy 
Glad to help and would appreciate you could makr this repy as accept😁