One option you have is to create calculated fields that have the desired header and hide the header on the sheet that has the metrics. Then you could create calculated fields that show the desired column headers add those as text objects on separate sheets.
Lastly, create a dashboard with the sheet that has the metrics and drag the header sheets as floating objects into the desired location. Check out the KB article below which has step-by-step instructions:
Hope this helps,