Rearranging rows with new column name

[KnimeUser1990]

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!

[izaychik63]

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.