Help creating reports from source data that share the Primary Column

vponis

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?

vponis

Thank you for the quick reply kirstie858!

kirstie858

Unfortunately, reports don't have any "join" functionality, only append. In order to see the data like you're describing, you'd have to create another sheet and bring the other columns in via index(match()) formulas, or use an application like PowerBI to connect to the two sheets, and join your data together that way.

vponis

Thank you for the quick reply kirstie858!