Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
User | Count |
---|---|
117 | |
75 | |
62 | |
50 | |
44 |
User | Count |
---|---|
174 | |
125 | |
60 | |
60 | |
57 |