Pivot table without merged columns

I have a data set:

When I do pivot in Knime the pivot columns are merged and the result is hard to read:

I would like to create a pivot table that does not merge my pivot columns:

How can I do it?:slight_smile:

Hi there @MarcinC,

welcome to KNIME Community!

Pivoting node canโ€™t do this and in general you canโ€™t have Excel format in KNIME so to say. What is you goal? Export data to Excel file or have better readability in KNIME?


thank you for the answer!

My goal is to have better readability. I can accept different form of the result.

Hi @MarcinC,

I see. Maybe Table View would be better then. Together with renaming your columns?


thank you! I wil try it:)

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.