> ## Content Index
> Fetch the complete content index at: https://www.vizney.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# How to Merge Header Cells in Tableau
- URL: https://www.vizney.com/merge-header-cells-in-tableau/
- Published: 2024-08-06T03:00:10.000Z
- Updated: 2024-09-25T08:25:42.000Z
- Description: This guide covers how to merge header cells, a common challenge when moving Excel-based documents into Tableau.
- Author: Yehwan Hwang
- Tags: Tips & Tricks

In Tableau, **Dimensions** are merged automatically based on their values, but there’s no feature to merge cells for **measures**, except by pivoting the data. This trick uses a Placeholder as a workaround.

### Step-by-Step: Merging Header Cells

1. Connect Placeholder data to your data source by following the provided guide.

[How to Add a Placeholder to Your Tableau Data SourceThis method explains how to connect Placeholder data, giving you more flexibility—similar to Excel—and enabling a broader range of visualizations.![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/icon/vizney_icon_b_1.0.png)VizneyColson Hwang![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/thumbnail/photo-1658203897339-0b8c64a42fba)](https://www.vizney.com/add-placeholder-to-tableau-data-source/)

1. Create two calculated fields to use as headers.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Level-1.png)

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Level-2.png)

1. Set the appropriate values for each header using the calculated fields.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Value.png)

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Proportion.png)

💡

Since you can only apply one format per measure, if you need different formats, you'll need to split the measure and create separate calculated fields for each one.

1. Place the calculated fields in the appropriate positions on the screen.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2024/09/Place-calculated-fields.png)