Unpivot the Excel file collectively

[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.