I have a list of duplicate cases (column A). Both duplicates have information that the other may or may not have. I would like to use INDEX MATCH to match the case number and return the first non empty value corresponding to the attribute in the event that the other duplicate is empty. I assume I would need to use a two-way INDEX MATCH.

Original data
Case Attribute1 Attribute2 Attribute3 Attribute4 Attribute5
1 36 (blank) 3 AO 3
1 (blank) apple 3 AO (blank)
2 (blank) orange (blank) (blank) 85
2 61 (blank) 3 AD (blank)
3 54 orange (blank) BL 40
3 (blank) (blank) 4 (blank) (blank)

Output I am looking for
Case Attribute1 Attribute2 Attribute3 Attribute4 Attribute5
1 36 apple 3 AO 3
2 61 orange 3 AD 85
3 54 orange 4 BL 40