Transforming data from columns to rows.
What is Transpose?
The Transpose Tool moves values held in multiple horizontal columns into a single column. Essentially, it makes a wide dataset narrower/ taller. Read my Importance of Data Structures and Pivoting blog for more information as to why you may need to transform your data.
Before
After
The Key columns stay unchanged, but data that was once headers transforms into rows.
Data example
Below we have an example with transportation data. We want to Transpose to create new month rows that is populated by two different columns: January and February and turns them into rows (columns to rows).
Before
↓
After
Transpose Tool on Alteryx
Objective:
Each row is a single month and single transportation combination. What is the total amount for each transportation for each month?
Let me know if you have any questions at sabrina.vazquez@theinformationlab.com.