Create Report source sheets? - Merge with same primary?

Kimbh ✭✭✭✭
edited 02/09/22 in Smartsheet Basics

Update: It works correctly but when I filter it shows the filter on two rows. Can I make it merge all rows with the same primary?

Hi, I created a report and pick both source sheets. The source sheets have the same primary ID however not in the same order. After picking the sources sheets, I pick the columns I want, those columns are created. Why does it only show one source sheet or the other source sheets, but not both source sheets at once? Since the primary ID are the same, should information from both source sheets show up?

Thank you