Formula Needed For Combining Rows with Exact Values in Separate Sheet

Hello Smartsheet Community,

I have a compliance tracker sheet that captures employee's HIPAA and FEMA certifications. I have been tasked with creating a dynamic view for their immediate supervisors. I have two separate views for FEMA and then HIPPA. However, I also have employees who have submitted separate reports for each individual FEMA module. And I would like in the dynamic view for these individuals to only appear once, however I am seeing an individual appear 5x (even if they have only 4 FEMA rows), there HIPPA row will appear too. So is there a formula or some type of way (whether creating a separate sheet/or running the view through a report) for me to combine these separate cells/rows into one row when the same individual submits multiple forms.

Thank you in advance,

Alan

Public Health