roberto
December 14, 2021, 7:29pm
2
Hey Rick,
In this case, you have to Unpivot once, delete a column that gets created with the unpivot, and then Pivot:
Here you can download this sample project: Vertical to horizontal.morph (4.1 KB)
When pivoting, the columns are automatically ordered by column name (from A to Z). If you want to keep the original/specific order in the columns, check out this article:
Hello,
i would like to pivot the data according to order.
So RowNo 1 = Column1, RowNo 2= Column 2 …
At the moment the columns are unsorted. It is not clear to me which order is used.
Is that possible?
Wasn’t there something like aggregate, groups … don’t know at the Moment, how it works
[grafik]
pivot_in_order.morph (2.2 KB) data.dset (526 Bytes)
Regards,
Adrian
Regards,
Roberto
1 Like