# Pivot/unstack/crosstab

**URL:** <https://community.easymorph.com/t/pivot-unstack-crosstab/3253>\
**Category:** General Q&A\
**Created:** [December 14, 2021, 5:38pm UTC](https://community.easymorph.com/t/pivot-unstack-crosstab/3253 "2021-12-14T17:38:12Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [December 14, 2021, 7:29pm UTC](https://community.easymorph.com/t/pivot-unstack-crosstab/3253/2 "2021-12-14T19:29:29Z")

</div>

Hey Rick,

In this case, you have to Unpivot once, delete a column that gets created with the unpivot, and then Pivot:

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

Here you can download this sample project: [Vertical to horizontal.morph](https://community.easymorph.com/uploads/short-url/r7at9R3pNvlk4wLZqaBnzNlPWOg.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:

> [@Pivot Columns in Order](https://community.easymorph.com/t/pivot-columns-in-order/2436):
>
> 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] [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

Regards,

Roberto

---

_[View the full topic](https://community.easymorph.com/t/pivot-unstack-crosstab/3253)._