Values in one column to become column headers

I am rather new user of Knime, thus some support is highly appreciated.
Attached picture shows covid-19 cases per month in four countries. Problem is that those countries are repeated in rows. I would like to find a way to have each country as own column maintaining that Year/Month column as it is.
Thank you very much for any advice.

Pivoting node may work for you


Hi @Maiju,

@izaychik63 is totally right. The Pivoting node will solve your problem. As I always feel a bit of pain when configuring this node, I attached you an example showing how to use it for your data:

Please don’t forget to select @izaychik63’s answer as solution.

Best regards,

1 Like

Dear @danielesser ; @izaychik63

I highly appreciate your support and prompt reply. With your help I manage to proceed with my case.

Kind regards

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