We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Group column values to become field names and another column to become the rows

lmoorlach
6 - Meteoroid

I need help pivoting my data but I'm not sure how with the way it is currently being input from the data source. I need the Name column to be grouped to become the field names and the values to become rows. 

 

Example: 

 

Screenshot 2025-01-12 203731.png

 

Desired Output:

Screenshot 2025-01-12 203812.png

 

Thank you!

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

Hi @lmoorlach ,

If the field names appear in the same pattern like this,

Tile Tool with "Unique Value" option would come in handy for grouping the data.

I hope this helps.

workflow.png

lmoorlach
6 - Meteoroid

That worked, thank you @Yoshiro_Fujimori!

Labels
Top Solution Authors