Forum Discussion
excel_learner
Nov 24, 2021Brass Contributor
Dashboard & Pivot tables help
Hi I'm trying to create some Pivot tables which will then link to a interactive Dashboard. The problem I have is that my data set has heading and subheadings for the columns. The heading has been m...
Riny_van_Eekelen
Platinum Contributor
excel_learner Can't really predict how this will work in the dashboard you are building, as I haven't been able to look at it.
excel_learner
Nov 24, 2021Brass Contributor
How would I just add the top row as another column so each heading is attributed to the subheadings.
it happens once you transpose table, but then the week no have separate columns which I don't want.
Is there a way I can just get the week no back to rows ?
- Riny_van_EekelenNov 25, 2021Platinum Contributor
excel_learner Looked at the original file again, but can't tell how an update would work. The file contains 12 queries, all of which seem to have issues. So, I can't check any of them to see how they will be affected.
Then, I don't really understand your last question about "weeks not having separate columns".