Help us build a better product, earn the PaxPro Advocate badge: Six short questions, one cool badge.
Transpose is the simplest of the Shape functions, essentially allowing you to switch your rows and columns (imagine rotating your data 90 degrees).
The transpose function allows you to select any one column to create new column headers with. The values of the selected column will become the new column headers, while all other column headers will shift and become row headers (unless the user removes them during the transpose process). In this new transposition, if there is more than one value that matches a particular set of headings, Paxata will display the last available value from the original dataset.
Here we have a simple sales dataset:
Upon opening the Shaping function, you will have four options to choose from. Selecting the "Transpose" button at the top of the Shaping window will open the Transpose options.
You will be able to choose one column for the column header (the values of this chosen column will become the new column headers) as well as any columns you would like to include as rows in the newly transposed data. Pay attention to the grid below the Shaping window as it will display a preview of how the data will appear based on the options you have chosen for the Transpose process.
Be aware, depending on which column you choose for your transpose, you may not end up with a complete picture of your data. Notice how in our example there is more than one instance where the "Item Sold" value is "Baseball". If you were to transpose with the "Item Sold" as your new columns, Paxata will only display the last value in the dataset, as shown here:
Once you are satisfied with the options you have chosen for the Transpose process, clicking the "Save" button in the upper-right hand corner of the screen will finalize and commit the process to your project.