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,
Solved! Go to Solution.
Hey Fiorano,
You can use the transpose tool,
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.
Hey Fiorano,
You can use the transpose tool,