Unpivot the Excel file collectively

[alex1368]

Hello
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

[mlauber71]

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

Move head rows to a column

@willy_oracle typically you would mark all lines with a Counter. Then identify the ‘headers’ with a rule engine [IF Col1 LIKE “Head*” => Counter] and keep that (starting) row in a separate column. Then you fill the missings with the previous value so a block would emerge marking the data table: [image] So now you have the blocks marked an can use a Table Row to Variable Loop Start – KNIME Community Hub or Group Loop Start – KNIME Community Hub to do something with the blocks (export them delet…

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.