Transpose or CrossTab - Not working?

[Ahmad_S]

Hi Team,

I have a small query and I am trying to fix the issue since last 1 day:

Current Data Structure:

Month | 01-01-20202 | 02-01-2020 | ....

App 1 | Event | No Event | ...

App 2 | Event | No Event | ...

Desired Data Structure:

Month | App 1 | App 2

01-01-2020 | ...

02-01-2020 | ...

It is change the dates in one column while the application name into other.

Appreciate if anyone from the community can help.

Regards

[ChrisTX]

These posts may help:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-or-cross-tab-help/m-p/376063...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Transpose-Question/m-p/345557#M63103

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Merge-rows-per-header/m-p/370022#M6795...

[Cndro_Consulting]

You can use transpose or crosstab to achieve this, probably you will need a text to column tool too.Can you mock up some data so I can understand you better? @Ahmad_S 

[AbhilashR · Accepted solution]

Hi @Ahmad_S, I have attempted to transpose your data based on how I interpret your dataset and requirement. Give this a try on your larger dataset and let us know if you run into challenges or if this isn't what you were looking for.

[Cndro_Consulting]

This is awesome @AbhilashR