Forum Discussion

dflock27's avatar
dflock27
New Member
4 years ago
Solved

Reference Table | Match One Column to Multiple Columns

Having an issue creating a reference table.  I have Ids in column A where I would like to return duplicate values for column A, while refencing column B and column C separately.  Here's the working situation:

 

I'd like my reference table to return (in seperate rows) each Away and Home value per GameId.  So the finish product would look something like this:

 

GameIdTeam
68831MIN
68831BOS
68828NYY
68828BAL
68840OAK
68840TOR

 

Here's a snapshot of my table.  Also, I'm sure this process is called something specific.  If someone knows, could you please let me know??

 

  • dflock27 Here you can unpivot two column in power query as per below snap:

     

     

    then remove 3rd column as its not required

     

     

    finaly close and apply:

     

     

1 Reply

  • ddpl's avatar
    ddpl
    Solution Sage

    dflock27 Here you can unpivot two column in power query as per below snap:

     

     

    then remove 3rd column as its not required

     

     

    finaly close and apply: