CODEWITHSUNDEEP
excelpowerbipowerquerymdata-transform
Koustuv Dutta
Koustuv Dutta

Reputation: 3

Transform data in rows to columnar form

I need to do a transformation in PowerBI.

From this,

Java    x   x1  x2
OS      y
MS      Z   Z2

to this,

Java    x
Java    x1
Java    x2
OS      y
MS      Z
MS      Z2

Thanks in advance!

Upvotes: 0

Views: 64

Answers (1)

PowerStar
PowerStar

Reputation: 895

You have to do Unpivot other colums in the Transform menu from edit queries. Please refer below pic.

enter image description here

Upvotes: 3

Related Questions