I have data exported from a system and for most of the exports i can use the Unpivot feature in Power Query to get it in the format i need.
However this last spreadsheet has an hours and Value column, and i need to keep the hours and Value parallel to each other rather than pulling them both into the same column.
I'm unsure that there will actually be an automatic work around for this, but i thought i'd post it to get your opinions anyway in hope that there is a solution!
I've attached two screen shots, what the current data looks like, and what i need it to look like.
Bookmarks