Spreadsheet: 93289d1292882822-match-id-and-return-adjacent-data-formatting1
Sheet: Sheet1

 |  |  |  | Key | 1st Occurrence |  | 2nd Occurrence |  | 3rd Occurrence |  | 4th Occurrence |  | 5th Occurrence
 |  |  |  |  | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5
Self | [NAME] | 111 |  | 111-1 | Self | [NAME] | Spouse | [NAME] | Child | child1 | Child | [NAME] | Child | child11
Self | [NAME] | 222 |  | 222-1 | Self | [NAME] | Spouse | [NAME] | Child | child2 | Child | [NAME] | Child | child12
Self | Holly | 333 |  | 333-1 | Self | Holly | Spouse | Hank | Child | child3 | Child | child8 | Child | child13
Self | [NAME] | 444 |  | 444-1 | Self | [NAME] | Spouse | Harold | Child | [NAME] | Child | child9 | Child | child14
Self | [NAME] | 555 |  | 555-1 | Self | [NAME] | Spouse | Virginia | Child | child5 | Child | child10 | Child | child15
Spouse | [NAME] | 111 |  | 111-2 | Self | [NAME] | Spouse | [NAME] | Child | child1 | Child | [NAME] | Child | child11
Spouse | [NAME] | 222 |  | 222-2 | Self | [NAME] | Spouse | [NAME] | Child | child2 | Child | [NAME] | Child | child12
Spouse | Hank | 333 |  | 333-2 | Self | Holly | Spouse | Hank | Child | child3 | Child | child8 | Child | child13
Spouse | Harold | 444 |  | 444-2 | Self | [NAME] | Spouse | Harold | Child | [NAME] | Child | child9 | Child | child14
Spouse | Virginia | 555 |  | 555-2 | Self | [NAME] | Spouse | Virginia | Child | child5 | Child | child10 | Child | child15
Child | child1 | 111 |  | 111-3 | Self | [NAME] | Spouse | [NAME] | Child | child1 | Child | [NAME] | Child | child11
Child | child2 | 222 |  | 222-3 | Self | [NAME] | Spouse | [NAME] | Child | child2 | Child | [NAME] | Child | child12
Child | child3 | 333 |  | 333-3 | Self | Holly | Spouse | Hank | Child | child3 | Child | child8 | Child | child13
Child | [NAME] | 444 |  | 444-3 | Self | [NAME] | Spouse | Harold | Child | [NAME] | Child | child9 | Child | child14
Child | child5 | 555 |  | 555-3 | Self | [NAME] | Spouse | Virginia | Child | child5 | Child | child10 | Child | child15
Child | [NAME] | 111 |  | 111-4 | Self | [NAME] | Spouse | [NAME] | Child | child1 | Child | [NAME] | Child | child11
Child | [NAME] | 222 |  | 222-4 | Self | [NAME] | Spouse | [NAME] | Child | child2 | Child | [NAME] | Child | child12
Child | child8 | 333 |  | 333-4 | Self | Holly | Spouse | Hank | Child | child3 | Child | child8 | Child | child13
Child | child9 | 444 |  | 444-4 | Self | [NAME] | Spouse | Harold | Child | [NAME] | Child | child9 | Child | child14
Child | child10 | 555 |  | 555-4 | Self | [NAME] | Spouse | Virginia | Child | child5 | Child | child10 | Child | child15
Child | child11 | 111 |  | 111-5 | Self | [NAME] | Spouse | [NAME] | Child | child1 | Child | [NAME] | Child | child11
Child | child12 | 222 |  | 222-5 | Self | [NAME] | Spouse | [NAME] | Child | child2 | Child | [NAME] | Child | child12
Child | child13 | 333 |  | 333-5 | Self | Holly | Spouse | Hank | Child | child3 | Child | child8 | Child | child13
Child | child14 | 444 |  | 444-5 | Self | [NAME] | Spouse | Harold | Child | [NAME] | Child | child9 | Child | child14
Child | child15 | 555 |  | 555-5 | Self | [NAME] | Spouse | Virginia | Child | child5 | Child | child10 | Child | child15