Combine two sheets to one report

Gaurav Chauhan

Hi Team

I am trying to combine two sheets into one report.

Have added the two sheets. But wondering if it is feasible to combine the two sheet columns and data into one where the data can sit against the common Project name vs below.

The Project nomenclature is the same on both sheets. Trying to see if we can have the desired result.

Paul Newcome

You could group your report by project and then use the report summaries to surface each column's data onto the one row.