Write new rows using specific fields

[ew87]

I need to create new rows if specific columns have a value, and then fill down. I know I can use the multi-row formula to fill down, but need assistance with how to best create the new rows.

I have attached an example data set. In this example, row 2 has values in the Name2 and Name3 columns. I need to create new rows (starting in row 4) using those values. So, row 4 should have Jane Smith (from row 2, column Name2) in the Name column. I then need to copy the values from group, date, status, and count fields from row 2 into the newly created row.

I then ultimately need to sum the values where they match - so in the example of Jane Smith, I would need to sum the Count for rows 3 and 4 if Name and Date match.

Any ideas? Happy to provide additional clarification if needed.

[CharlieS · Accepted solution]

I've attached an example solution that shows one way to achieve this. Let me know if you have any questions.