I cannot pivot in excel (source data).

I have tried to pivot as part of my data flow and have not been successful. Can you help me out here please

The data in the table looks like this:

ID Date Value

10 getdate() 1.357

The ID is generated by running a query to select name from another table where name matches the column name on the spreadsheet.