Hi together, I have the following scenario. I have a column header with subcategories (Excel-file): [image] 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

Hello @Schmali93 , see here: [image] Excel Reader Merged Cells KNIME Analytics Platform 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

Combine separate column headers

KNIME Analytics Platform

ipazin January 26, 2021, 9:51am 2

Hello @Schmali93 ,

see here:

Br,
Ivan

2 Likes