Consolidating multiple sheets into a single report line

Hello,


I want to pull a report that compares 2 sheets. Both sheets have the columns and the same primary header

 I can create a report which pulls them in as pairs of rows (1 line from project sheet, 1 line from data sheet) but I want the data on a single row, not on pairs of rows.

 Any suggestions on how to do this?

Answers