Tableau Prep is a great tool for dealing with messy or unorganized data. After understanding the basics, one of the first things I found myself wondering was “does Tableau Prep have the ability to unpivot data?”. It has a pivot feature but does not have an unpivot or transpose feature at this point. However, there is a workaround.
Imagine you have a dataset that looks like this:
The first step (after connecting to the data) will be to add a clean step and create a calculated field for each measure:
When this is done, there are going to be some large null sections for each measure. That is okay. We’ll deal with that momentarily:
You can now remove the Measure and Values fields.
From there we can add the created measures to “Aggregated Fields” and the other dimensions to “Grouped Fields”:
From there the data can be exported and is unpivoted: