In the reports I've used so far a new row is created for each sheet data is pulled from. Is there a way of combining the results on one row where the primary column is the same?
For example, if I have project RAG status in Sheet1 and project financials in Sheet2, and both sheets have the identical project name as the Primary Column, can I get the report to show only one row per project with columns from both sheets presented on the single row?
The only workaround I can think of for this is creating a Sheet3 that links to the other two sheets, however for the volume of data I'm working with this is not ideal.
