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 s...