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. But 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~~~, ,
Field, Associate's, Bachelor's, Master's, Doctoral, Profesional
Law, 1, 1, 1, 1, 1
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 the following 2 settings -  make sure that they are both selected! 

1. Merge with empty cells

Then go down to Customize header section on the same page: 

2. Add first row to header

That's it!