Merge data from 2 sheets into 1 row

DonnaG

In a report, would be great to be able to use two sheets to feed a report and reflect the information from both sheets on 1 single row, avoiding duplicates if the same project is showing on the two sheets. If the project is on both sheets, I'd like to merge them to the same rows. Right now, they are on separate rows, even if the column names and similar matches.

Courtney S.

This would be a really neat new kind of report to have! We definitely have situations where the same participant ID is in multiple sheets tracking different kinds of work. It could be useful to have a report that showed one row per participant, with participant data from more than one sheet.