How to Transpose/pivot multiple rows at once?

[BrianDeg]

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:	US	UK	India
Country ID:	101	102	103
Country Loc:	NA	EUR	ASIA
Sales:	10	11	12
Costs:	5	10	4
Profits	5	6	8

Trying to turn that into the following:

Country Name	Country ID	Country Loc	Type	Value
US	101	NA	Sales	10
UK	102	EUR	Sales	11
India	103	ASIA	Sales	12
US	101	NA	Costs	5
UK	102	EUR	Costs	10
India	103	ASIA	Costs	4
US	101	NA	Profits	5
UK	102	EUR	Profits	6
India	103	ASIA	Profits	8

Thank you for your help!

[fmvizcaino · Accepted solution]

Hi @BrianDeg ,

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

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

Best,

Fernando Vizcaino