Help creating reports from source data that share the Primary Column

Hello! I hope someone can help me with the query below.

I have two Sheets that share the Primary Column but any other column is different . I want to create a report that displays the content from both sheets under the same line if they have a Primary column in common. In the example below, the row would display A under Primary column and C and D under the C and D columns, all on the the same line instead of duplicating the record like in the screenshot. What am I doing wrong?

Best Answer