Spreadsheet: 809808d1671335027-match-values-in-columns-on-2-different-sheets-test-match
Sheet: Merge1

date | Other | ID | Program | name | Event date | Event Type | [NAME] | Name.1
2021-05-01 00:00:00 | Attended | 0002215/1 | Jumping | [NAME] | 2021-05-01 00:00:00 | Note | Group1 | [NAME]
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-01 00:00:00 | Other | Group1 | [NAME]
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-02 00:00:00 | Note | Group6 | [NAME]
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-06 00:00:00 | Care | Group3 | [NAME]
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-08 00:00:00 | Other | Group5 | Wiley Coyote
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-11 00:00:00 | Note | Group3 | [NAME]
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-13 00:00:00 | Note | Group19 | [NAME]
2021-05-03 00:00:00 | Attended | 06695/1 | Rowing | [NAME] | 2021-05-03 00:00:00 | Note | Group5 | [NAME]
2021-05-03 00:00:00 | Attended | 06695/1 | Rowing | [NAME] | 2021-05-09 00:00:00 | File | Group1 | [NAME]
2021-05-03 00:00:00 | Attended | 06695/1 | Rowing | [NAME] | 2021-05-12 00:00:00 | Note | Group15 | New Person
2021-05-07 00:00:00 | Attended | 06695/1 | Jumping | [NAME] | 2021-05-03 00:00:00 | Note | Group5 | [NAME]
2021-05-07 00:00:00 | Attended | 06695/1 | Jumping | [NAME] | 2021-05-09 00:00:00 | File | Group1 | [NAME]
2021-05-07 00:00:00 | Attended | 06695/1 | Jumping | [NAME] | 2021-05-12 00:00:00 | Note | Group15 | New Person
2021-05-13 00:00:00 | Attended | 06695/1 | Sky Jumping | New Person | 2021-05-03 00:00:00 | Note | Group5 | [NAME]
2021-05-13 00:00:00 | Attended | 06695/1 | Sky Jumping | New Person | 2021-05-09 00:00:00 | File | Group1 | [NAME]
2021-05-13 00:00:00 | Attended | 06695/1 | Sky Jumping | New Person | 2021-05-12 00:00:00 | Note | Group15 | New Person
2021-05-15 00:00:00 | Attended | 06695/1 | Skiing | Jelly Fish | 2021-05-03 00:00:00 | Note | Group5 | [NAME]
2021-05-15 00:00:00 | Attended | 06695/1 | Skiing | Jelly Fish | 2021-05-09 00:00:00 | File | Group1 | [NAME]
2021-05-15 00:00:00 | Attended | 06695/1 | Skiing | Jelly Fish | 2021-05-12 00:00:00 | Note | Group15 | New Person
2021-05-05 00:00:00 | Attended | 06695/2 | Skipping | [NAME] | 2021-05-04 00:00:00 | File | Group2 | [NAME]
2021-05-05 00:00:00 | Attended | 06695/2 | Skipping | [NAME] | 2021-05-08 00:00:00 | Care | Group1 | [NAME]
2021-05-05 00:00:00 | Attended | 06695/2 | Skipping | [NAME] | 2021-05-11 00:00:00 | File | Group7 | [NAME]
2021-05-09 00:00:00 | Attended | 06695/2 | Jumping | [NAME] | 2021-05-04 00:00:00 | File | Group2 | [NAME]
2021-05-09 00:00:00 | Attended | 06695/2 | Jumping | [NAME] | 2021-05-08 00:00:00 | Care | Group1 | [NAME]
2021-05-09 00:00:00 | Attended | 06695/2 | Jumping | [NAME] | 2021-05-11 00:00:00 | File | Group7 | [NAME]
2021-05-11 00:00:00 | Attended | 06695/2 | Skipping | [NAME] | 2021-05-04 00:00:00 | File | Group2 | [NAME]
2021-05-11 00:00:00 | Attended | 06695/2 | Skipping | [NAME] | 2021-05-08 00:00:00 | Care | Group1 | [NAME]
2021-05-11 00:00:00 | Attended | 06695/2 | Skipping | [NAME] | 2021-05-11 00:00:00 | File | Group7 | [NAME]
2021-05-12 00:00:00 | Attended | 0023414/3 | Jumping | Grow Up | 2021-05-12 00:00:00 | Other | Group11 | Grow Up
2021-05-03 00:00:00 | Attended | 06695/1 | Rowing | [NAME] | 2021-05-14 00:00:00 | Care | Group27 | Jelly Fish
2021-05-07 00:00:00 | Attended | 06695/1 | Jumping | [NAME] | 2021-05-14 00:00:00 | Care | Group27 | Jelly Fish
2021-05-13 00:00:00 | Attended | 06695/1 | Sky Jumping | New Person | 2021-05-14 00:00:00 | Care | Group27 | Jelly Fish
2021-05-15 00:00:00 | Attended | 06695/1 | Skiing | Jelly Fish | 2021-05-14 00:00:00 | Care | Group27 | Jelly Fish
2021-05-02 00:00:00 | Attended | 0023414/1 | Running | [NAME] | 2021-05-16 00:00:00 | Note | Group31 | [NAME]
2021-05-04 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-16 00:00:00 | Note | Group31 | [NAME]
2021-05-06 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-16 00:00:00 | Note | Group31 | [NAME]
2021-05-08 00:00:00 | Attended | 0023414/1 | Skiing | Wiley Coyote | 2021-05-16 00:00:00 | Note | Group31 | [NAME]
2021-05-10 00:00:00 | Attended | 0023414/1 | Rowing | [NAME] | 2021-05-16 00:00:00 | Note | Group31 | [NAME]
2021-05-14 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-16 00:00:00 | Note | Group31 | [NAME]
2021-05-16 00:00:00 | Attended | 0023414/1 | Jumping | [NAME] | 2021-05-16 00:00:00 | Note | Group31 | [NAME]