Forum Discussion
Date row to column
I have a typical spreadsheet with dates as the top row, then the first column is the employee name, second column is a task they worked on, then the remaining columns are the number of hours they worked for a corresponding date. I need the dates to be a column as well is there a way to do this? I thought I had done this before in Power BI but I cannot figure it out or find a similar posting about this issue.
HI dbragdon314
Edit the table in Power Query, and from memory, select the first two columns (Employee Name and Task) and use the "Unpivot other columns" option from the modelling tab
1 Reply
- Phil_Seamark
Microsoft Employee
HI dbragdon314
Edit the table in Power Query, and from memory, select the first two columns (Employee Name and Task) and use the "Unpivot other columns" option from the modelling tab