Reference Table | Match One Column to Multiple Columns

[dflock27]

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:

GameId	Team
68831	MIN
68831	BOS
68828	NYY
68828	BAL
68840	OAK
68840	TOR

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??

[ddpl · Accepted solution]

@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: