Pivot Columns in Order

1

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 :relaxed:

grafik
grafik1114×417 13.8 KB

pivot_in_order.morph (2.2 KB) data.dset (526 Bytes)
Regards,

Adrian

2

Hey Rebmanna,

Check this out:

1 Like
3

Hi Roberto,

thank you for your answer, unfortunately I didn’t get it that way.
But the “alphabetical order” was a good comment :+1:

I solved it with Rename with lookup. Thanks again

Solution:

image
image1176×608 24 KB

image
image1160×584 24.4 KB

4

That’s it :slightly_smiling_face:

5

Great! Hadn’t thought about that way of doing it!