What is Pivot in Tableau?

If your data is structured perfectly for analysis right from the start, you're one of the lucky few. For most of us, data comes in a "wide" format that's easy for humans to read but difficult for visualization tools like Tableau to understand. This article will show you how to use Tableau's powerful, yet simple, Pivot feature to quickly reshape your data so you can get to the insights you need faster.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Your Data Shape Matters: Wide vs. Tall

Before jumping into the how-to, it’s essential to understand why you need to pivot. Most data can be structured in one of two ways: wide or tall. Tableau almost always prefers tall data.

The Problem with "Wide" Data

Wide data is probably what you're used to seeing in spreadsheets. It organizes information by spreading it across multiple columns. For example, imagine you have a spreadsheet tracking monthly sales for different products:

At first glance, this seems perfectly logical. However, for Tableau, it's a nightmare. Each month's sales metric is a separate field (a unique measure). If you wanted to create a simple line chart showing sales trends over time, you’d have to drag each "month" pill onto the view individually. If you had 12 months, you'd have 12 separate measures. This is inefficient, hard to manage, and almost impossible for creating flexible, filterable visuals.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Power of "Tall" Data

Tall data, on the other hand, structures the same information into fewer columns with more rows. It's the ideal format for most data analysis tools. Here’s what the same sales data looks like in a "tall" format:

Suddenly, things are much clearer for Tableau. You now have:

• A Product dimension.
• A Month dimension.
• A single, continuous Sales measure.

With this structure, creating that line chart is as easy as dragging "Month" to the Columns shelf and "Sales" to the Rows shelf. The process of converting your data from that troublesome wide format to this analysis-friendly tall format is exactly what Tableau's Pivot feature is for.

What is a Pivot in Tableau, Exactly?

A pivot in Tableau is a data preparation tool that transforms data by converting columns into rows. It effectively "un-pivots" a wide dataset into a tall one, making it structured and ready for easy analysis and visualization within Tableau Desktop.

If you're familiar with Pivot Tables in Excel, you might be a little confused. Be careful: their functions are essentially opposites.

• In Excel, a Pivot Table takes tall, raw data and aggregates it into a wide, summarized view for human readers.
• In Tableau, the Pivot function takes wide, raw data and reshapes it into a tall format so the software can analyze it effectively.

Think of it as the foundational step you take before you start building your vizzes, ensuring your data is in the best possible shape from the very beginning.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step-by-Step: How to Use the Pivot Feature in Tableau

Using the pivot feature is straightforward and happens on the Data Source page immediately after you connect to your data. Let's walk through it with our sales example.

1. Connect to Your Data: First, connect to your data source in Tableau (e.g., an Excel or CSV file). Once connected, you will see a preview of your data on the Data Source page. You should see the "wide" format we discussed earlier.
2. Select the Columns to Pivot: Identify all the columns you want to consolidate into rows. In our example, these are Jan_Sales, Feb_Sales, Mar_Sales, and Apr_Sales. You can select multiple columns by holding down the Ctrl key (or Cmd key on a Mac) and clicking on each column header. Alternatively, you can click the first column, hold down the Shift key, and click the last column to select the entire range.
3. Activate the Pivot: With the columns highlighted, right-click on any of the selected column headers. From the dropdown menu that appears, simply click "Pivot."

That’s it! Tableau will instantly transform those columns into two new ones.

1. Rename Your New Fields: Tableau automatically names the new columns "Pivot Field Names" and "Pivot Field Values." These are generic, so it's best practice to give them meaningful names.

• Pivot Field Names: This column contains the original column headers (e.g., "Jan_Sales", "Feb_Sales"). You can rename this to something like "Month".
• Pivot Field Values: This column contains the actual data from those original columns (e.g., 150, 165, 180). You should rename this to reflect what the numbers represent, such as "Sales Amount".

To rename them, simply double-click on the column header and type your new name.

1. Verify Your Tall Data: Your data preview will now show the beautiful, "tall" structure, ready for analysis. You can now go to a worksheet and start building your dashboards with well-structured dimensions and measures.

When Should You Use a Pivot? Common Scenarios

While our month-over-month sales example is common, here are a few other real-world scenarios where pivoting is a lifesaver.

1. Survey Data

Survey tools often export data with each question as a separate column (e.g., "Q1_Response," "Q2_Rating," etc.). To analyze responses across all questions, you can pivot these columns to get a "Question" field and a "Response" field, allowing you to easily compare sentiment or ratings.

2. Comparing Metrics Side-by-Side

Sometimes you have multiple related metrics in separate columns that you want to compare as part of a single category. For example, columns for "Facebook Ad Spend", "Google Ad Spend", and "LinkedIn Ad Spend". Pivoting these creates two new fields:

• A dimension you can call "Ad Platform" (containing the values "Facebook Ad Spend," "Google Ad Spend," etc.).
• A measure you can call "Spend" (containing the corresponding dollar amounts).

Now you can easily build a bar chart comparing performance across platforms with a single drag-and-drop action.

Graphed

Still Building Reports Manually?

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

Watch the Demo

3. Check-All-That-Apply Responses

When you have a set of columns representing options, like "Product Feature A," "Product Feature B," etc., with values like 1 for selected and 0 for not selected, pivoting can consolidate them. This allows you to easily filter and count which features are most popular.

Pro Tips and Common Issues

• Not all data sources are supported: The native Pivot function works with non-cube data sources like Excel, text files (CSVs), Google Sheets, and some database connections. If you're using a published Tableau data source or a database that doesn't support pivoting at this level, the "Pivot" option may be greyed out. In these cases, you might need to use Tableau Prep Builder or create a custom SQL query to reshape the data first.
• Adding more data later: What if a new column is added to your source file (e.g., "May_Sales")? A great feature in Tableau allows you to automatically include new columns. After creating your initial pivot, you can select the pivoted columns, right-click, and choose "Add Data to Pivot."
• Pivot works on the physical layer: Pivoting is a permanent change to the structure of your data within the Tableau data model. It isn't a temporary view like a filter, it's a foundational transformation.

Final Thoughts

At its core, Tableau's Pivot feature solves one of the most common hurdles in data analysis: improperly formatted source data. By quickly transforming your wide tables into a tall, organized structure, you enable Tableau to work its magic, saving you from the headache of wrangling individual measures and making it far easier to create powerful, flexible visualizations.

For all the time spent reshaping data, connecting different marketing and sales platforms, and wrangling CSVs, we created a way to skip those steps entirely. We built Graphed to be your AI data analyst. You just connect your data sources - like Shopify, Google Analytics, or Facebook Ads - one time. Then, our AI agent automatically understands the underlying structure. Instead of manually pivoting your data to create a chart, you can just ask in plain English: "Show me a line chart of Shopify revenue vs Facebook ad spend over the last six months," and the dashboard gets built for you in real-time.