# Pivot Columns in Order

**URL:** <https://community.easymorph.com/t/pivot-columns-in-order/2436>\
**Category:** General Q&A\
**Created:** [February 3, 2021, 4:34pm UTC](https://community.easymorph.com/t/pivot-columns-in-order/2436 "2021-02-03T16:34:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![rebmanna](https://community.easymorph.com/user_avatar/community.easymorph.com/rebmanna/32/938_2.png) [@rebmanna](https://community.easymorph.com/u/rebmanna)\
**Post date:** [February 3, 2021, 4:34pm UTC](https://community.easymorph.com/t/pivot-columns-in-order/2436/1 "2021-02-03T16:34:59Z")

</div>

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](https://community.easymorph.com/uploads/default/original/2X/6/60defdb2d1df2e26e3cf4add34dc2f3952f8cdd3.png)  
[pivot\_in\_order.morph](https://community.easymorph.com/uploads/short-url/60iOCrWoaWJKRo5rWfcgtbVDMCR.morph) (2.2 KB) [data.dset](https://community.easymorph.com/uploads/short-url/9FCwSbuE5cfBYodTEw1XpwSUeNP.dset) (526 Bytes)  
Regards,

Adrian

---

<div class="post-metadata">

**Author:** ![roberto](https://community.easymorph.com/user_avatar/community.easymorph.com/roberto/32/8595_2.png) [@roberto](https://community.easymorph.com/u/roberto)\
**Post date:** [February 3, 2021, 7:03pm UTC](https://community.easymorph.com/t/pivot-columns-in-order/2436/2 "2021-02-03T19:03:09Z")

</div>

Hey Rebmanna,

Check this out:

> [@Sorting when pivoting](https://community.easymorph.com/t/sorting-when-pivoting/964):
>
> Hi, De action to pivot a dataset always sorts alphabetically. Is it possible to change this so that we keep de order in which the dataset was in de original long format ? Thanks, Nikolaas

---

<div class="post-metadata">

**Author:** ![rebmanna](https://community.easymorph.com/user_avatar/community.easymorph.com/rebmanna/32/938_2.png) [@rebmanna](https://community.easymorph.com/u/rebmanna)\
**Post date:** [February 4, 2021, 7:36am UTC](https://community.easymorph.com/t/pivot-columns-in-order/2436/3 "2021-02-04T07:36:26Z")

</div>

Hi Roberto,

thank you for your answer, unfortunately I didn't get it that way.  
But the "alphabetical order" was a good comment 👍

I solved it with Rename with lookup. Thanks again

Solution:

 ![image](https://community.easymorph.com/uploads/default/original/2X/2/26bbd2b5e203b0267ddbac931042748ce5aa54a5.png)

 ![image](https://community.easymorph.com/uploads/default/original/2X/5/56f54e053cba1d06abf3b76bd0facf43c81e1038.png)

---

<div class="post-metadata">

**Author:** ![rebmanna](https://community.easymorph.com/user_avatar/community.easymorph.com/rebmanna/32/938_2.png) [@rebmanna](https://community.easymorph.com/u/rebmanna)\
**Post date:** [February 4, 2021, 3:12pm UTC](https://community.easymorph.com/t/pivot-columns-in-order/2436/4 "2021-02-04T15:12:25Z")

</div>

That's it 🙂

---

<div class="post-metadata">

**Author:** ![roberto](https://community.easymorph.com/user_avatar/community.easymorph.com/roberto/32/8595_2.png) [@roberto](https://community.easymorph.com/u/roberto)\
**Post date:** [February 4, 2021, 5:30pm UTC](https://community.easymorph.com/t/pivot-columns-in-order/2436/5 "2021-02-04T17:30:06Z")

</div>

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