Pivoting data is one of my favorite uses of the Data Prep tool. I’ve done this task in a variety of tools over the years, but none were as easy or as intuitive as Prep. As usual, we begin with a short discussion of when and why you might want to pivot (or unpivot) your data.
For me, the single biggest use case for pivoting data involves survey data. In almost all cases, your analytics will benefit from pivoting raw survey data. Why is this the case? Because frequently Tableau just works better when the data you are trying ...
