If you need to pivot data from a SQL table for use in Tableau, Tableau Desktop’s default pivot feature can’t help you.
So what can you do? You have two readily available alternatives.
Your second option is to use the Pivot Function in Tableau Prep (or another data preparation tool). That function doesn’t limit you like its counterpart in Tableau Desktop.
Need more guidance on how to prepare your data for Tableau? Check out our upcoming workshop Data & Tableau in early January for more tips like this.