I want to combine two sheets in a report.
Say the report has 5 columns.
The first 4 columns would be from sheet 1, of which the 1st column would be a date column and the rest 3 aren’t of concern.
The 5th column along with the 1st column, would be from sheet 2, from which the 1st column would be a date column as well.
I hope I’m making sense.
How would I combine the two sheets in the report?