We can group headers in Revit schedules to create a new header above. It would look something like the image below.
To do this, select multiple header cells > Group (from the Titles & Headers panel). This will create an empty cell above the selected cells that will allow you to type any text. Some examples can be seen below.
To remove the group header, select the cell > Ungroup (from the Titles & Headers panel).