columns to rows

[newbie9]

I like to change the columns to rows

I like to change from left format to right format

either in power query or excel

[DOLEARY85 · Accepted solution]

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 👍

[ahmedoye · Accepted solution]

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.

[Nandha_Kumar_SR · Accepted solution]

go to power  Query,
select your table,

select Date Column
go to transform tab, 

Click Pivot

select Value

[ahmedoye · Accepted solution]

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.

[DOLEARY85 · Accepted solution]

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 👍