Change matrix format

All I have a table with the below structure


I need to transform the data to get something like this:

Transpose node will help me to do the transpose columns to rows but it won’t go question by question adding all the countries and their values.

Any ideas?

Hi @chaconq,

The Unpivoting and Pivoting nodes can be used for this task:

un_pivot.knwf (25.4 KB)



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