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:
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.
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