How to create a double-row-header

Our tables make it possible to create a double-row-header, like so: 

In this article, we will explain how to achieve such a header in two simple steps, with two settings: Merging cells & adding the first row to the header. Bur first, we need to get the data right:

1

Prepare the data

To merge cells in your header, you need to include empty cells in your data. If you import or paste from a spreadsheet software like Excel or Google Sheets, simply leave the cells in the header empty. If you import a CSV, it should look like this:

 ,~~~Undergraduate~~~, , ~~~Graduate~~~, ,<br>
Field, Associate's, Bachelor's, Master's, Doctoral, Profesional<br>
Law, 1, 1, 1, 1, 1<br>
Medicine, 2, 2, 2, 2, 2

The cells will always merge with empty cells to its right. So "Undergraduate" will merge with "X.2", not with "X.1".

That's how it looks like in step 2: Check & Describe:

Include three ~~~ wiggly lines before and after your header cell text to create a line like in the chart at the beginning of the article. However, that's not mandatory.

1

Choose the right settings

Now that we prepared the data, we can go on to step 3: Visualize. Choose the "Table" chart type and go to the Refine tab.

There you see many settings; but for our header, we're especially interested in these two: "merge with empty cells" and "add first row to header".

Make sure they're checked to have a proper double-row header!

Still need help? Contact Us Contact Us