Alteryx designer Discussions

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

How to Transpose/pivot multiple rows at once?

Highlighted
5 - Atom

Hello! I am looking for help with how to transpose multiple rows at the top of a spreadsheet within Alteryx. The first three rows of my spreadsheet are all headers for the data below it, so I want to transpose all of them. Below are examples of what I am hoping to do:

Initial Data with first three rows being column headers

Country Name:USUKIndia
Country ID:101102103
Country Loc:NAEURASIA
Sales:101112
Costs:5104
Profits568

 

Trying to turn that into the following:

Country NameCountry IDCountry LocTypeValue
US101NASales10
UK102EURSales11
India103ASIASales12
US101NACosts5
UK102EURCosts10
India103ASIACosts4
US101NAProfits5
UK102EURProfits6
India103ASIAProfits8

 

Thank you for your help!

Highlighted
Alteryx Certified Partner

Hi @AndyDegeneres ,

 

Attached is an example showing how to do it. It was a matter of playing with cross tab and transposes.

fmvizcaino_0-1581574315130.png

 

 

Take a look and let me know if that works for you.

Best,

Fernando Vizcaino

Labels