Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 |
Solved! Go to Solution.
@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
@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
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.