LinkBack URL
About LinkBacks
Does anyone know how I can unpivot this data with excel power query or regular excel? I want the data to be down the column and the column headers should be row entries.
Does anyone know how I can unpivot this data with excel power query or regular excel? I want the data to be down the column and the column headers should be row entries.
It sounds as if you want to transpose the data which could be done by copying and pasting transpose by month as modeled in columns J:S on Sheet1 or as complete block as modeled in rows 5:12 on sheet2.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks