How to Depivot a Report with Data I Need for a Workflow

[Shelly3]

One of my data sources will be a pivoted table of data with three column headers and several row headers. Previously, I used Microsoft Power Query to move all the row headers to column headers so I could apply various formulas to change the data before re-pivoting it. Which Alteryx tool allows me to do the 'depivot' part of that?

[fmvizcaino · Accepted solution]

Hi @Shelly3 ,

If I understood your problem fully, you can use cross tab to achieve what you are looking for.

https://help.alteryx.com/current/designer/cross-tab-tool

IF that doesn't help you, please share a sample and I help you a little more.

Best,

Fernando Vizcaino