Pivot Data from Columns to Rows Pivot data from columns to rows(which is also called as wide format to long format) can be done in Tableau for only Excel sources. If we use any data sources we need to create the view in database by using multiple UNION's as explained in sql below. For example, suppose you have the number of devices sold by quarter for three vendors in three separate fields. You can pivot your data so that the vendor is in one field and the number of devices sold is in another field. Pivot the data After you have set up the data source, in the grid, select two or more columns. Click the drop-down arrow next to the column name, and then select Pivot . New columns called "Pivot field names" and "Pivot field values" are created and added to the data source. The new columns replace the original columns that you selected to create the pivot. Add to the pivot To add more data to the pivot, select another column, click the ...