Relate values of two columns in the same table (Power Query)

[Anonymous]

First, my apologies because this must be easy and already answered, but I can't figure it out, nor find a post with a solution.

I think two images will show what I am trying to do much better than what I could explain, so here they are:

InputWanted output   

I need to do it with Power Query and not DAX because the actual tables are a little bit trickier...

I appreciate your help 🙂

[Ashish_Mathur]

Hi,

@ImkeFshould be able to help with the appropriate M code for solving this.  @Anonymous, in the second image, you have not shown the KeyB column.  Please show us the entries that should appear there.

[Anonymous · Accepted solution]

Try breaking those into two queries, and then merging on the ID. You can duplicate and hack away the columns accordingly.

[Anonymous]

I knew I was missing something. Thanks for taking the time to answer my silly question.