Combine separate column headers

[Schmali93]

Hi together,

I have the following scenario.

I have a column header with subcategories (Excel-file):

Is it possible to combine the different categories to one header to get something like this:

Q1/2021-test1 Q1/2021-test2 Q1/2021-test3 etc.

Thank you in advance.

Best regards,

Andreas

[ipazin]

Hello @Schmali93 ,

see here:

Excel Reader Merged Cells

Hey, guys. I have an excel and it has merge cells. When I run the excel reader, knime places the columns to the right of the merge as null. Any help on how I could change for him to repeat the name on the others as he does on the first? Or how can I enter the value of the first ones on the right? [Untitled]

Br,
Ivan

[Schmali93]

Hello @ipazin ,

that was exactly what I was looking for!

Thank you!

Best regards,

Andreas