Merging columns from 2 sheets that are filtering through to 1 report

Hi there,

I was wondering if someone can please help.

I have created a report on smartsheets. Two separate sheets flow through to this report.

Both the "Branch/Department" columns flow through to the report but I don't want to have two columns that are "Branch/Department" , to make it simple is there any way of being able to merge these?