Forum Discussion
dflock27
4 years agoNew Member
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:
| 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??
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: