Log In
Register
Home
April 4, 2019
Offline
I have a data range that uses dates as headers for several of the columns. The headers look something like this:
Task Budget Jan-19 Feb-19 Mar-19 (etc.)
Under each month is a value associated with the tasks that make up the rows. Task and Budget are typical table headers, but the months are actual data I want to use. When I convert that range to a table in order to extract the data for analysis, I cannot figure out how to demote only the months so I can unpivot the table with the month values in the data and not identified as headers.
July 16, 2010
Offline
Hi Eric,
You don't need to demote the headers first. Just unpivotand then the dates will be in a column of their own as they should be i.e. in a tabular format.
If you get stuck, please upload a sample file so we can show you.
Mynda
April 4, 2019
Offline
Thanks for the response, Mynda. I tried what you suggested and just can't see how that will work. I've uploaded a sample file as you requested.
July 16, 2010
Offline
Hi Eric,
You haven't given me an example of the desired result, so in the attached file I've just unpivoted the data and put it in the sheet called Query and then used a PivotTable for the report. I hope that helps. If there was something else you had in mind, please provide an example of what you were expecting.
Note: you can't use a formula in a table header. You could place the dates in the first row of the table instead, and then promte the first row as headers in Power Query before unpivoting.
Mynda
1 Guest(s)
