Community Halloween is live until October 31st! Complete any 2 quick activities to earn the 2025 Community Halloween badge. Feeling brave? Check out the activities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Shelly3
5 - Atom
‎03-09-2021 02:49 PM

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?

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor
‎03-09-2021 03:01 PM

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

 

Reply
0 Likes
Community Live Fifa Workshop
Labels
Top Solution Authors
View All