Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Dear Experts,
In the last couple of week, I've been working on an excel table and I would like to know if there is a possibility to move an especific cell to another position (sort of like an unpivot)
I get the data as it looks like in the yellow color image, and I'm trying to unpivot the data with power query but I would also like to try to move the cell from the green color position to the red one (next image)
Is this possible with power query?
How I get the data
I am capable of transforming the table to a estructure database, however I would like to get that red color cell in another column.
I am attaching you the PBIX in which i've been working on. (the example file is attached)
Solved! Go to Solution.
is this what you are after?
Dear @Anonymous ,
This is exactly what I needed it 😄
Thanks a lot!
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.