I'm trying to merge data from 2 sheets onto 1 sheet or even a report.

I don't want to have duplicate rows w/ the same primary column though.

I want all the data for the same Primary column value on each sheet to be merged into 1 row on the consolidated sheet/report.

Why isn't this possible?