Pivot table without merged columns

[MarcinC]

Hi,
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?

[ipazin]

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?

Br,
Ivan

[MarcinC]

thank you for the answer!

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

[ipazin]

Hi @MarcinC,

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

Br,
Ivan

[MarcinC]

thank you! I wil try it:)