Alteryx Designer Desktop Discussions

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

Rows to Columns

Dpharr
6 - Meteoroid

I've been an Alteryx user for a while, but I'm needing some help structuring data in a way I can use it. Below is a small test sample that I currently have verse how I need it to be - How can I use Alteryx to make this happen?

 

What I have:

 

Dpharr_2-1643989886035.png

 

 

 

 

The structure I need:

 

Dpharr_3-1643989922926.png

 

 

This is probably a very simple question, but I am having an issue using the cross tab function to make this happen. Notice the column headers I need are actually the percentage level.

 

Please help...

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Dpharr 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1643990379736.png

 

Hope this helps : )

 

Labels