This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. 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!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.