Start Free Trial

Alteryx Designer Desktop Discussions

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

Convert rows to be header of columns

thua
7 - Meteor

Hi guys,

 

Can you help me with the below: What tools will I use to make the fees, unit-price and vendor be a header columns?

Much appreciated!!!

 
 

image.png

I want it to look like this:

Screenshot 2025-03-23 at 9.00.33 PM.png

2 REPLIES 2
flying008
15 - Aurora

Hi, @thua 

 

FYI.

 

录制_2025_03_24_12_27_22_648.gif

ntakeda
12 - Quasar

@thua 

I created a workflow.
First,  Transpose tool to convert each record into a key and data pair.
Next, Crosstab tool to transform the data into a table.

For details, please check the attached workflow.

 

2025-03-24_13h30_49.png

Labels
Top Solution Authors