Merging multiple rows into one single header row

[Analyst_Nick]

Hello!

I am quite new to KNIME.
I am trying to concatenate multiple Excel files together, however, their header rows are in multiple rows like this:

Is there a way how to merge first 3 rows in a single header row without doing it manually in Excel?

Regards,
Nick

[HansS]

Hi @Analyst_Nick

Welcome to the KNIME forum. I created an example flow to fix your issue. Its not fully automated. In the row splitter you have to define the number of rows your header consist of.
Merging multiple rows into one single header row.knwf (15.7 KB)

Succes,

gr
Hans

[armingrudd]

Hi,

Although @HansS has provided the solution to merge the header rows, here I have a solution to merge headers and also assign them as the column headers:

column_headers.knwf (24.9 KB)

Best,
Armin

[Analyst_Nick]

This is great, thank you!

[Analyst_Nick]

Hi, thank you for your input! Your version is a bit faster.