HELP! Anyone know how to replace values in a column based on values in a column (like a VLOOKUP) in a dataflow?

Like (0) Share

Report

Posted on 10 Dec 2021 01:03:20 by arpost

455

I have an unpivoted table for which I need to replace column attributes with a set of column values. It's probably easier for me to visualize. Here's the starting point:

I am wanting to replace the "Column#" values in the Attribute column so they match the "header" values in the Value column (i.e., Column1 becomes OrderID, Column2 becomes Item, etc.); this would be the desired result:

If this were Excel, I'd probably just do a VLOOKUP, but I'm not sure how to achieve that with Power Query without resorting to a separate query.

I have the same question (0)

All responses (1)

Answers (0)

arpost 455 on 10 Dec 2021 at 02:02:52

Like (0)

Report

Re: HELP! Anyone know how to replace values in a column based on values in a column (like a VLOOKUP)

Thanks, @Syndicate_Admin! That was staring me in the face…

Was this reply helpful? Yes No