CODEWITHSUNDEEP
powerbipowerquerydata-analysispowerbi-desktopdata-cleaning
shg
shg

Reputation: 15

How to transpose in power bi desktop

I am having a table with 3 columns, where I need to transpose using Power Bi desktop. This is the structure I need:

See this picture

I started using Power Query Editor, but seems like it to not transforming the way I need in the picture above. Any ideas?

Upvotes: 1

Views: 1927

Answers (2)

GCO
GCO

Reputation: 11

Inside Power Query, click on Transform, then Unpivot Columns.

Three options are available, pick the one that fits best for you.

You may check how-to using the following screenshot: Unpivot Columns

Upvotes: 1

davidebacci
davidebacci

Reputation: 30289

Highlight the row column and select unpivot other columns from the transform tab on the ribbon.

Upvotes: 1

Related Questions