Date row to column

[dbragdon314]

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.

[Phil_Seamark · Accepted solution]

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