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 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's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft 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