columns to rows

Hi,

you can do this in power query editor,

open power query editor: 

select the date column

select pivot column on the transform ribbon

in the drop down select your value column

Result:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

In Power Query, go to the Transform Tab, select the Date Column, then click on "Pivot Column" button.

For Values column, select "value".

If this works for you, please remember to mark it as a solution so it can be of help to anyone else searching for similar solutions.

go to power  Query,
select your table,

select Date Column
go to transform tab, 

Click Pivot

select Value