TOPIC: Transpose rows to (variable) columns

Hello,
is there way to group and to transpose the rows to varaible columns? The rows as well as the columns can be variable.

please, see below a simple example:



thanks for your software and support!


regards

Hi Gennaro,

You can do that with the help of the GroupBy Heater and for each (row) column you need one IF-THEN-ELSE Heater to decide which content you want to store in which column on the WRITE side.

For the condition you need one additional AutoID Heater . The Heater counts per each group from 1 to how often the same Code (group) is available. For each column you need a condition like this.

= 1 = for the first read row = the first write column
= 2 = for the second read row = the second write column

I've made a brief example (rows to columns) based on your example data; please have a look to the attachment.

thanks a lot!