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

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.

Sample Input.xlsx

Sample Output.xlsx

Input

Accepted answers

This should work for your use case.

0210-ToxicBuoy.yxzp

All comments

This should work for your use case.

0210-ToxicBuoy.yxzp

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?

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703