Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi Power BI Community,
I'm looking to orginise my data by the Issue id at the moment my data looks like this:
I would like it to look like this:
ABC issue_id | ITP Item No. | ITP No. | Verification Activity by | Lot No. | |
1 | 0252a62d - 3e09-4545 - a2cf - 035ec850e433 | 4.5 | HSEQ - QC - ITP002 - GEO - 2077 | 4a3e930f - a6bd - 4757 - b22d - 7caf0fddfa13 | |
2 | 053c4f89-8a83-4d2a - adb5 - a6496decee37 | 1.4 | HSEQ - QC - ITP002 - GEO - 2077 | e20c3f7a - fa11-45d3 - a711-6fb8abb7367c | |
3 | 057b9582-565d - 4e89 - a7f7 - e8c32655a363 | 2.5 | HSEQ - QC - ITP002 - GEO - 2077 | e20c3f7a - fa11-45d3 - a711-6fb8abb7367c | 0 |
4 | 0724d97e - 294b - 4a11 - a036-5dd09779a0f6 | 4.5 | HSEQ - QC - ITP002 - GEO - 2077 | 4a3e930f - a6bd - 4757 - b22d - 7caf0fddfa13 | |
5 | Ofbd25e4-4901-4dca - 8f79-8e984b09a8b8 | 4.6 | HSEQ - QC - ITP002 - GEO - 2077 | 4a3e930f - a6bd - 4757 - b22d - 7caf0fddfa13 | |
6 | 131a6e92-5aa2-4c68 - ba22-4de7e23db6e3 | 4.5 | HSEQ - QC - ITP002 - GEO - 2077 | ed53094e - 1bbe - 4699-8bac - 421711a7be35 |
Note that there may be more columns added in the future.
The only way I know to do this at the moment is by a conditional column and then say if column "attribute_title" contains "ITP No." then = "attribute_value" and then go though all the values and clean it all up in the end.
I hope you are able to help thanks.
Solved! Go to Solution.
Hi, @RevitUser
do pivot on value col and select the don't aggregate option.
Proud to be a Super User!
Thank you very much both of you. The pivot function was what I was looking for!
Hi, @RevitUser
do pivot on value col and select the don't aggregate option.
Proud to be a Super User!
NewStep=Table.Combine(Table.Group(YourTable,"issue_id",{"n",each #table({"issue_id"}&[attribute_title],{{[issue_id]{0}}&[attribute_value]})})[n])
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.