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

Pivot/unstack/crosstab
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

Option to specify column order for Pivot
4

That's it :slightly_smiling_face:

5

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