Forum Discussion
Solved
Covert row into column
want to convert "Value1234.1" to row with it's respective values from first three columns and Value1234.2 column.
Example:
Data:
| S_NodeId | S_Cell | Attribute | Value1234.1 | Value1234.2 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1314147 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1344046 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1336352 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1344046 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1336352 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1336352 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1320445 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1337382 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1320445 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1314621 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1351878 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1346518 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1322062 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1341083 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1320445 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1314148 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1333527 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1314256 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | gNBId | 1337382 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 2 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 2 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 3 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 2 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 302 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 2 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 3 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 303 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 3 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 1 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 303 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 2 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | cellLocalId | 303 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 190 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 29 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 649 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 19 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 702 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 644 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 148 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 853 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 162 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 694 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 656 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 102 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 42 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 860 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 170 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 390 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 44 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 406 |
| M1WA6375A | K1WA6375A31 | lwNeighborRel | nRPCI | 68 |
PSB , Try pivot in power query
https://radacad.com/pivot-and-unpivot-with-power-bi
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12
1 Reply
PSB , Try pivot in power query
https://radacad.com/pivot-and-unpivot-with-power-bi
Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12