Unpivot the Excel file collectively

I have a folder that contains a large number of Excel files, and the Excel files are in such a way that they cannot be consolidated normally, and they must be UNPIVIT first and then consolidated.
But I don’t know how to do it and there are too many files and I can’t convert manually please help me
The sample file and the output file in my opinion are as follows

@alex1368 you might have to identify the blocks of the tables and import them separately (in a loop) and then unpivot them:

You will have to know which pattern(s) would match your files. This will involve some planning

Do you have any idea if they might be formatted/marked as excel tables.


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.