Pulling multiple columns from one (query, tables) into another according to multiple conditions

Hi @HMK 

I've updated the PBIX for you in the attached. I've done it all in Power Query by creating a new key and then Appending the tables into a new table.  PBIX file is attached.

The appended table (new table) looks like below.  You can change / adjust as you want in Power Query, too, by just deleting whatever columns, etc, you don't want.

Let me know if you need anything else 🙂

Theo