Transpose Columns to Rows

[fiorano]

Hi,

I have the following sample data :

Unit	Type1	Type2	Type3
SouthWest		-	3,542
MidWest	3	12,360	97,737
Northern 1	5	7,775
South East 5	2	-	242,352

is it possible to transpose it to the following:

Unit	Type	Total
SouthWest	Type3	3,542
MidWest	Type1	3
MidWest	Type2	12,360
MidWest	Type3	97,737
Northern1	Type1	5
Northern1	Type2	7,775
South East 5	Type1	2
South East 5	Type3	242,352

This is just an example as there maybe upto 60 'Types' that are in individual columns.

Many thanks,

[PhilipMannering]

Hey Fiorano,

You can use the transpose tool,

[JShankman]

Transpose tool followed by a select tool to rename the columns. Then you would want to filter on the Total column to get rid of the empty or "-" fields. Make sure the "Dynamic or Unknown Fields" box is checked in the Transpose tools data fields to ensure additional "Type" columns get picked up.

[PhilipMannering · Accepted solution]

Hey Fiorano,

You can use the transpose tool,

Transpose tool