How to Move Columns in Tableau

Getting your table visualization just right in Tableau often comes down to one simple task: putting your columns in the right order. A logically arranged table is easier to read, helps you tell a clearer story with your data, and just looks more professional. This guide will walk you through the various ways to move and reorder columns in Tableau, from the basic drag-and-drop to handling more complex crosstabs.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

The Easiest Way: Drag and Drop in Your View

Tableau is known for its user-friendly, interactive interface, and rearranging columns is a perfect example of this. The most direct method is to reorder the column headers right in your main worksheet view.

Imagine you have a simple table showing Sales, Profit, and Quantity by Sub-Category. By default, Tableau might arrange the measures alphabetically, giving you Profit, then Quantity, then Sales. But you likely want to see Sales first. Here’s how to fix that.

1. Create your basic table by dragging a dimension (like Sub-Category) to the Rows shelf and a few measures (like Sales, Profit, and Quantity) to the Columns shelf or onto the table itself.
2. In the table visualization, find the header of the column you want to move. For instance, find the header labeled "Sales."
3. Click and hold your mouse on the "Sales" header.
4. Drag the header horizontally to its new position. As you drag, Tableau will show a faint orange triangle or a dark line indicating where the column will be dropped.
5. Let’s say you want it to be the very first column. Drag it all the way to the left until you see the indicator before the "Profit" column.
6. Release the mouse button. The column will snap into its new place, and your table is now ordered exactly as you need it.

This method is quick, intuitive, and perfect for making fast adjustments as you explore your data. It's the go-to technique for simple tables and text-based reports.

Using the Shelves for More Control

Another fundamental way to control column order is by using the Columns shelf at the top of your workspace. Every "pill" you place on this shelf corresponds to a column (or a set of columns) in your visualization. The order of the pills from left to right directly controls the order of the columns in your table.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Reordering Dimension and Measure Pills

Tableau treats dimensions (blue pills, which are categorical data like 'Region' or 'Product Name') and measures (green pills, which are numerical data like 'Sales' or 'Quantity') differently. By default, it will group all your dimensions together, followed by all your measures. But what if you want a measure to appear between two dimensions?

Let's say you have Region, Category, and SUM(Sales) on your Columns shelf. Your table will show columns for Region, then Category, and finally Sales.

To change this order:

1. Go to the Columns shelf at the top of your Tableau worksheet.
2. Find the pill you want to move. For example, the green SUM(Sales) pill.
3. Click and hold the pill. A dark arrow will show you where it can be placed.
4. Drag it between the Region and Category pills. You'll see the indicator appear between the two blue pills.
5. Release the mouse. Your table will instantly update to show a new column order: Region, then Sales, then Category.

This method gives you precise control over the layout and is essential for building more complex views where you need to mix descriptive dimensions and quantitative measures.

Working with Hierarchies

Dragging pills on the Columns shelf is also how you control hierarchies. If you have "Year" and then "Quarter" on your columns, your data will be structured with years as the main column group, and quarters nested within each year. If you simply drag the "Quarter" pill so it's in front of the "Year" pill on the shelf, the visualization will flip. Now, your main columns will be the quarters (Q1, Q2, etc.), with the years nested inside them. This is a powerful way to change how your data story is framed.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

How to Reorder Columns in a Crosstab (Measure Names & Values)

Things get a little different when you’re working with a crosstab that involves multiple measures. This is a very common scenario in business reporting, where you might want to see Sales, Profit, Profit Ratio, and Number of Customers all in one table, broken down by region.

To do this in Tableau, you typically use two special generated fields: Measure Names (to create the column headers for each measure) and Measure Values (to fill in the data for each of those measures).

When you build a viz this way, dragging the column headers in the new view won't work. Trying to reorder them on the Columns shelf also won’t work because there's only one pill there: Measure Names.

So, how do you reorder these columns? You use the Measure Values card.

1. Set up your crosstab. Drag a dimension like Region to the Rows shelf. Then, drag the special Measure Names field from the Data Pane to the Columns shelf.
2. Drag the measures you want to include (e.g., Sales, Profit, Profit Ratio, Quantity) onto the Measure Values card. This card automatically appears on the left side of your workspace below the Marks card. It will now list all the measures you've included.
3. Your view will populate with a column for each measure.
4. To reorder the columns, simply go to the Measure Values card.
5. Click and drag the measures within this card into your desired order. For instance, if you want Sales to be first, drag it to the top of the list in the card. If you want Profit next, drag it under Sales.
6. As you reorder the fields in the Measure Values card, the columns in your table will update instantly and in real time.

This is a critical skill for anyone building financial statements, performance scorecards, or any report that requires comparing multiple metrics side-by-side.

Advanced Tips on Column Management

Once you've mastered the basics, here are a few more tips to give you even greater control over your table layouts.

Sorting vs. Reordering: Know the Difference

It's easy to confuse rearranging columns with sorting data, but they accomplish different things:

• Reordering Columns: This changes the horizontal position of an entire column (e.g., moving the 'Profit' column to be before the 'Sales' column). You do this with the drag-and-drop methods described above.
• Sorting Data: This changes the vertical order of the rows in your table based on the values within one or more columns (e.g., sorting your Sub-Categories from highest to lowest sales). You do this by clicking the sort icon on a column header or axis.

Understanding this distinction is fundamental. Reordering changes your report's structure, while sorting organizes the content within that structure.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Creating Combined Fields

Sometimes you have two dimensions that should always be displayed together, like Category and Sub-Category. To prevent them from being separated and simplify your layout, you can create a combined field.

1. In the Data Pane, hold the Ctrl key (or Command key on Mac) and select the two fields you want to combine (e.g., Category and Sub-Category).
2. Right-click on one of the selected fields.
3. Go to Create > Combined Field.
4. A new field will appear in your Data Pane (e.g., Category & Sub-Category (Combined)).

Now, you can drag this single combined pill to your view. It acts as one item, keeping the two fields locked together, making your column management on the shelves cleaner and simpler.

Using Blank Placeholders for Spacing

What if you want to create visual space between columns? A common trick is to use a placeholder field.

1. Double-click on an empty area of the Columns shelf.
2. A text box will appear. Type in two double quotes: "" and press Enter. This creates an ad-hoc calculated field with no content.
3. A new column pill will appear on the shelf. You can drag this pill to position a blank column wherever you need a visual gap in your table.
4. To clean it up, right-click the " " header in your table and select "Edit Alias." You can change it to a single space or leave it empty so the header disappears. Then, simply resize the column to create whatever spacing looks best.

Final Thoughts

Learning how to effectively reorder columns is a foundational skill in Tableau that transforms your data from a jumble of numbers into a clear, readable report. Whether you're using a simple drag-and-drop on the column headers, reordering pills on a shelf, or arranging fields in the Measure Values card, you now have the tools to create perfectly formatted tables for any audience.

The time spent manually clicking, dragging, and experimenting in tools like Tableau to get a report looking just right is something we understand deeply. It's why we built Graphed to remove this friction. Instead of building tables and dashboards by hand, you can just ask in plain English, "Show me a table of sales and profit by region for last quarter," and our tool handles the rest, automatically creating a clean, organized visualization. We believe getting insights from your data should be a conversation, not a configuration puzzle.