did you want to just show the header in the data?
there are 2 issues - first - it is good that all the tabs are have the same columns - you can combine them in Tableau (or Tableau Prep) with a simple Union
Just drag the sheets on top of each other and they will form a Union (append)
but then you will want to pivot the data to form a long thin file of data see the link - Pivot Data from Columns to Rows
it is real easy to do
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
In the data pane, drag out the 'New Union' box, and drop all 3 sheets into the union. You'll then automatically get a column that represents the sheet name, and you can alias the generic sheet name's to match your sites.
This is perfect, thank you!
Now I am running into the problem that the sum of the hours is calculating incorrectly after the pivot because the original data source contains a row for total. See attached for an updated excel document with this displaying. When I pivot this data, is there a way to include the “total” row?
Example Data.xlsx 10.1 KB
You are welcome