Hi, I have the following sample data : Unit Type1Type2Type3 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 TypeTotal SouthWest Type3 3,542 MidWest Type13 MidWest Type2 12,360 MidWest Type3 97,737 Northern1 Type1 5 Northern1 Type27,775 South East 5 Type12 South East 5 Type3 242,352 This is just an example as there maybe upto 60 'Types' that are in individual columns. Many thanks,

Transpose Columns to Rows

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,

Developer Tools

Transformation

Accepted answers

philipmannering

Hey Fiorano,

You can use the transpose tool,

Transpose tool

All comments

philipmannering

Hey Fiorano,

You can use the transpose tool,

Transpose - Capture.PNG

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

Hey Fiorano,

You can use the transpose tool,

Transpose tool

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703