Rearranging rows with new column name

Hey community,

I need to perform a task like this (in big scale):


So far I managed to extract the different characteristics types out of the characteristics column but I struggle with rearranging the value data. I need to have a loop of probably something like “Extract first 3 lines, transpose, add to table”, Extract second 3 lines, etc."

Any suggestions?
Thanks in advance!

Use Pivot node. Group on Object, pivot on Characteristic and use value as aggregation.
To have same names - chose in Column Name drop down Pivot name option.


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