How to Transpose Data in Tableau

Transforming your data's layout from columns to rows is a foundational step for effective analysis in Tableau, but it's not labeled as a simple "transpose" button. This process, often called pivoting or unpivoting, restructures your data from a wide format to a tall one, making it much easier to visualize and explore. This tutorial will walk you through exactly how to reshape your data using both Tableau Desktop and Tableau Prep Builder.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does Data Shape Matter? Wide vs. Tall Data

Tableau is optimized to work with "tall" data rather than "wide" data. Understanding the difference is the first step in mastering data preparation for any kind of analysis.

Wide data often resembles a crosstab or spreadsheet made for human eyes. It typically uses columns to represent time periods or categories. For example, monthly sales data might look like this:

Wide Format Example:

While this is easy to read, it's difficult for Tableau to analyze. You can't easily filter by month, create a single line chart showing the trend over time, or calculate total sales without creating a custom calculation ([Jan_Sales] + [Feb_Sales]...). Each new month requires updating your workbook formulas.

Tall data, on the other hand, organizes the same information into fewer columns with more rows. Each row represents a single observation.

Tall Format Example:

This tall format is analysis-friendly. You now have a "Month" dimension you can use for filtering, grouping, or displaying on an axis. You also have a single "Sales" measure, which makes aggregation (SUM, AVG) simple. Transposing your wide data into this tall format is what the pivot function does.

Method 1: How to Transpose (Pivot) in Tableau Desktop

For simple datasets from file-based sources like Excel or CSVs, you can pivot directly within Tableau Desktop's Data Source pane. It's quick and effective for straightforward data shaping.

Step-by-Step Instructions:

1. Connect to Your Data: In Tableau Desktop, connect to your Excel, text file (.csv), or Google Sheet that contains the wide-formatted data. This will automatically take you to the Data Source page.
2. Select Columns for Pivoting: In the preview pane at the bottom, identify the columns you want to "unpivot" into rows. Using our example above, these would be Jan_Sales, Feb_Sales, and Mar_Sales. Click on the first column header (Jan_Sales), hold down the Shift key, and then click the last column header (Mar_Sales) to select them all. If the columns are not next to each other, hold down the Ctrl key (or Command on Mac) and click each column individually.
3. Apply the Pivot command: With the columns highlighted, right-click on any of the selected column headers. From the context menu that appears, choose Pivot.
4. Rename the Pivoted Fields: Tableau instantly reshapes your data and creates two new columns: "Pivot Field Names" and "Pivot Field Values".

That's it! Your data is now structured in a tall format, ready for analysis. You can navigate to a new worksheet and start building visualizations, like dragging "Month" to Columns and SUM(Sales) to Rows to create a trend line.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Limitations of Pivoting in Tableau Desktop

While useful, this method has some limitations:

• Data Source Support: The Pivot option is not available for all data sources. It generally works for file-based sources and some database connections, but may be greyed out for others.
• Static Transformation: If new columns are added to your source data (e.g., an Apr_Sales column in your spreadsheet), you must manually go back to the Data Source pane, edit the pivot, and add the new column. It doesn't update automatically.
• Single Pivot Only: You can only perform one pivot action per table in the Data Source pane.

Method 2: A More Robust Solution with Tableau Prep Builder

When you have more complex data preparation needs, need to repeat the process, or are dealing with a data source that doesn't support pivoting in Desktop, Tableau Prep Builder is the ideal tool. It provides a visual, flow-based interface to clean, shape, and combine your data before you even bring it into Tableau for analysis.

Step-by-Step Instructions:

1. Connect to Your Data: Open Tableau Prep Builder and connect to your data source, just like in Desktop. Your data will appear as an input step at the top of the flow pane.
2. Add a Pivot Step: Click the plus (+) icon next to your input step and select Pivot from the menu. This adds a dedicated pivot transformation to your workflow.
3. Configure the Pivot (Columns to Rows): The Pivot pane has two main sections. For transposing, we are converting Columns to Rows.
4. Clean and Rename: Tableau Prep automatically names the new columns based on the original field names. Just as you did in Desktop, click on the column headers in the results pane to rename them to "Month" and "Sales." This step in your flow ensures all transformations are clean and well-documented.
5. Add an Output Step: After your data is shaped perfectly, click the plus (+) icon on your Pivot step and select Output. Here you can save the prepared data as a local file (like a .hyper file for fast performance in Tableau) or publish it directly to Tableau Server or Cloud as a new, curated data source.

Bonus: The Reverse Pivot (Tall to Wide) in Tableau Prep

Tableau Prep can also handle the opposite transformation: pivoting from a tall format back to a wide one. This is less common for analysis but can be useful for creating specific crosstab-style exports.

1. In the Pivot step, switch from the default "Columns to Rows" to "Rows to Columns."
2. Drag the field that contains your headers (e.g., "Month") into the "Field to pivot row values into columns" pane.
3. Drag the field that contains your values (e.g., "Sales") into the "Field to aggregate for new columns" pane and choose a default aggregation (like SUM or MIN).

Prep will then create a new column for each unique value in your "Month" field, effectively reversing the process we just completed.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

Transposing data in Tableau is a simple but powerful technique to unlock deeper analytical possibilities. You can perform a quick transformation directly in Tableau Desktop for simple use cases or leverage the repeatable, visual power of Tableau Prep Builder for more complex and ongoing data preparation tasks.

Constantly wrangling spreadsheets and reshaping data in Tableau Prep before you can get to the actual insights is a time-consuming first step for many teams. We built Graphed to eliminate these manual data prep hurdles altogether. You can connect sources like Google Analytics, Shopify, or Salesforce, and our AI-powered analyst handles the underlying structure for you. You don't need to worry if the data is wide or tall, you simply ask questions in plain English to build real-time dashboards and reports in seconds, letting you skip the boring data cleanup and get straight to making decisions.