Forum Discussion

dbragdon314's avatar
dbragdon314
New Member
8 years ago
Solved

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 wor...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    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