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 …

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] [image]

EasyMorph Community - Data preparation professionals and enthusiasts

Pivot Columns in Order

roberto February 3, 2021, 7:03pm 2

Hey Rebmanna,

Check this out:

1 Like

To learn more about EasyMorph visit easymorph.com.