Creating Reports from Different Sheet

Hello team, I am trying to create a report from two different sheets. The concern that i am having is that in case i have same Columns in two sheets reports are picking these as two entries rather than single. So what basically i am looking is to create a join so only one row should return rather than multiple. Kindly let me know if possible.