Brandon-6109 avatar image
0 Votes"
Brandon-6109 asked

Move Specific Row Cells to Column Power Query


I am trying to figure out how to move 2 specific row cells to their own column. I have tried to Transpose, Unpivot, Merge Cells and Transpose, Use first row as headers and everything I can try to my knowledge and what I could find on the internet forums.

So, what I am exactly looking for is to be able to create a new column with that information in the blue circle without having to adjust the raw data sheet to make it work.


Thank you in advance, I am no expert at this and still learning.

Thanks again,


image.png (59.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers