Spreadsheet: 725453d1616683386-extracting-non-adjacent-data-from-table-using-a1-syntax-in-the-formula-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do I extract this data using (A1#,,) syntax ?
 | Date | Course | Distance | Condition | Class | Time | Day | State | Track Location |  |  | Course | Distance | Class | Time | Date | Day | State | Track Location |  | Course | Distance | Class | Time | Date | Day | State | Track Location
 | 2021-02-26 00:00:00 | ALBURY | 900 | Good | Btria-Open | 00:00:54.390000 |  | NSW | Prov |  |  |  | 900 | Btria-Open | 00:00:54.390000 | 2021-02-26 00:00:00 | Friday | NSW | Prov |  | ALBURY | 900 | Btria-Open | 00:00:54.390000 | 2021-02-26 00:00:00 | Friday | NSW | Prov
 | 2021-02-26 00:00:00 | ALBURY | 1175 | Good | Mdn | 00:01:10.780000 |  | NSW | Prov |  |  | ALBURY | 1175 | Mdn | 00:01:10.780000 | 2021-02-26 00:00:00 | Friday | NSW | Prov |  | ALBURY | 1175 | Mdn | 00:01:10.780000 | 2021-02-26 00:00:00 | Friday | NSW | Prov
 | 2021-02-04 00:00:00 | ALBURY | 1600 | Good | Mdn | 00:01:39 |  | NSW | Prov |  |  | ALBURY | 1600 | Mdn | 00:01:39 | 2021-02-04 00:00:00 | Thursday | NSW | Prov |  | ALBURY | 1600 | Mdn | 00:01:39 | 2021-02-04 00:00:00 | Thursday | NSW | Prov
 | 2020-09-21 00:00:00 | ARARAT | 2000 | Heavy | Mdn | 00:02:10.850000 |  | VIC |  |  |  | ARARAT | 1100 | BM58 | 00:01:06.990000 | 2020-09-21 00:00:00 | Monday | VIC | Country |  | ARARAT | 1100 | BM58 | 00:01:06.990000 | 2020-09-21 00:00:00 | Monday | VIC | Country
 | 2021-02-07 00:00:00 | ARARAT | 1300 | Good | Mdn | 00:01:18.850000 |  | VIC |  |  |  | ARARAT | 1300 | Mdn | 00:01:18.850000 | 2021-02-07 00:00:00 | Sunday | VIC | Country |  | ARARAT | 1300 | Mdn | 00:01:18.850000 | 2021-02-07 00:00:00 | Sunday | VIC | Country
 | 2020-11-08 00:00:00 | ARARAT | 3800 | Good | BM70 | 00:04:05.200000 |  | VIC |  |  |  | ARARAT | 2000 | BM70 | 00:02:03.810000 | 2021-02-07 00:00:00 | Sunday | VIC | Country |  | ARARAT | 2000 | BM70 | 00:02:03.810000 | 2021-02-07 00:00:00 | Sunday | VIC | Country
 | 2021-02-07 00:00:00 | ARARAT | 2000 | Good | BM70 | 00:02:03.810000 |  | VIC |  |  |  | ARARAT | 2000 | Mdn | 00:02:06.540000 | 2021-02-07 00:00:00 | Sunday | VIC | Country |  | ARARAT | 2000 | Mdn | 00:02:10.850000 | 2020-09-21 00:00:00 | Monday | VIC | Country
 | 2021-02-07 00:00:00 | ARARAT | 2000 | Good | Mdn | 00:02:06.540000 |  | VIC |  |  |  | ARARAT | 3800 | BM70 | 00:04:05.200000 | 2020-11-08 00:00:00 | Sunday | VIC | Country |  | ARARAT | 3800 | BM70 | 00:04:05.200000 | 2020-11-08 00:00:00 | Sunday | VIC | Country
 | 2020-09-21 00:00:00 | ARARAT | 1100 | Heavy | BM58 | 00:01:06.990000 |  | VIC |  |  |  | ARMIDALE | 1000 | Btria-Open | 00:00:58.220000 | 2019-04-25 00:00:00 | Thursday | WA | Metro |  | ARMIDALE | 1000 | Btria-Open | 00:00:58.220000 | 2019-04-25 00:00:00 | Thursday | WA | Metro
 | 2021-01-25 00:00:00 | ARMIDALE | 1300 | Good | Mdn | 00:01:16.650000 |  | WA |  |  |  | ARMIDALE | 1300 | Mdn | 00:01:16.650000 | 2021-01-25 00:00:00 | Monday | WA | Metro |  | ARMIDALE | 1300 | Mdn | 00:01:16.650000 | 2021-01-25 00:00:00 | Monday | WA | Metro
 | 2019-04-25 00:00:00 | ARMIDALE | 1000 | Good | Btria-Open | 00:00:58.220000 |  | WA | Metro |  |  | AVOCA | 1200 | BM52 | 00:01:13.750000 | 2020-10-17 00:00:00 | Saturday | VIC | Country |  | AVOCA | 1200 | BM52 | 00:01:13.750000 | 2020-10-17 00:00:00 | Saturday | VIC | Country
 | 2020-10-17 00:00:00 | AVOCA | 1200 | Soft | BM52 | 00:01:13.750000 |  | VIC |  |  |  | BALLARAT | 1100 | Mdn | 00:01:06.890000 | 2021-03-09 00:00:00 | Tuesday | VIC | Country |  | BALLARAT | 1100 | Mdn | 00:01:06.890000 | 2021-03-09 00:00:00 | Tuesday | VIC | Country
 | 2021-03-09 00:00:00 | BALLARAT | 1100 | Soft | Mdn | 00:01:06.890000 |  | VIC |  |  |  | BALLARAT | 1400 | BM64 | 00:01:25.450000 | 2020-10-22 00:00:00 | Thursday | VIC | Country |  | BALLARAT | 1400 | BM64 | 00:01:25.450000 | 2020-10-22 00:00:00 | Thursday | VIC | Country
 | 2020-09-30 00:00:00 | BALLARAT | 1400 | Soft | Mdn | 00:01:30.300000 |  | VIC |  |  |  | BALLARAT | 1400 | Mdn | 00:01:30.300000 | 2020-09-30 00:00:00 | Wednesday | VIC | Country |  | BALLARAT | 1400 | Mdn | 00:01:30.300000 | 2020-09-30 00:00:00 | Wednesday | VIC | Country
 | 2020-10-22 00:00:00 | BALLARAT | 1400 | Good | BM64 | 00:01:25.450000 |  | VIC |  |  |  | BALLARAT | 1600 | BM64 | 00:01:41.300000 | 2021-02-28 00:00:00 | Sunday | VIC | Country |  | BALLARAT | 1600 | BM64 | 00:01:41.300000 | 2021-02-28 00:00:00 | Sunday | VIC | Country
 | 2020-08-23 00:00:00 | BALLARAT | 3200 | Heavy | Hrdle | 00:04:03.900000 |  | VIC |  |  |  | BALLARAT | 3200 | Hrdle | 00:04:03.900000 | 2020-08-23 00:00:00 | Sunday | VIC | Country |  | BALLARAT | 3200 | Hrdle | 00:04:03.900000 | 2020-08-23 00:00:00 | Sunday | VIC | Country
 | 2021-02-28 00:00:00 | BALLARAT | 1600 | Good | BM64 | 00:01:41.300000 |  | VIC |  |  |  | BALLARAT | 3200 | Mhdle | 00:04:03.870000 | 2020-08-23 00:00:00 | Sunday | VIC | Country |  | BALLARAT | 3200 | Mhdle | 00:04:03.870000 | 2020-08-23 00:00:00 | Sunday | VIC | Country
 | 2020-08-23 00:00:00 | BALLARAT | 3200 | Heavy | Mhdle | 00:04:03.870000 |  | VIC |  |  |  | BALLARAT SYNTHETIC | 1400 | Mdn | 00:01:25.730000 | 2020-06-11 00:00:00 | Thursday | VIC | Country |  | BALLARAT SYNTHETIC | 1400 | Mdn | 00:01:25.730000 | 2020-06-11 00:00:00 | Thursday | VIC | Country
 | 2020-06-11 00:00:00 | BALLARAT SYNTHETIC | 1400 | Synthetic | Mdn | 00:01:25.730000 |  | VIC |  |  |  | BALLARAT SYNTHETIC | 2100 | BM58 | 00:02:14.500000 | 2020-10-09 00:00:00 | Friday | VIC | Country |  | BALLARAT SYNTHETIC | 2100 | BM58 | 00:02:14.500000 | 2020-10-09 00:00:00 | Friday | VIC | Country
 | 2020-10-09 00:00:00 | BALLARAT SYNTHETIC | 2100 | Synthetic | BM58 | 00:02:14.500000 |  | VIC
 |  |  |  |  |  |  |  |  |  |  |  |  | 900 | Btria-Open
 |  |  |  |  |  |  |  |  |  |  |  | ALBURY | 1175 | Mdn | 00:01:10.780000
 |  |  |  |  |  |  |  |  |  |  |  | ALBURY | 1600 | Mdn | 00:01:39
 |  |  |  |  |  |  |  |  |  |  |  | ARARAT | 1100 | BM58 | 00:01:06.990000
 |  |  |  |  |  |  |  |  |  |  |  | ARARAT | 1300 | Mdn | 00:01:18.850000
 |  |  |  |  |  |  |  |  |  |  |  | ARARAT | 2000 | Mdn | 00:02:06.540000
 |  |  |  |  |  |  |  |  |  |  |  | ARARAT | 2000 | BM70 | 00:02:03.810000
 |  |  |  |  |  |  |  |  |  |  |  | ARARAT | 3800 | BM70 | 00:04:05.200000
 |  |  |  |  |  |  |  |  |  |  |  | ARMIDALE | 1000 | Btria-Open | 00:00:58.220000
 |  |  |  |  |  |  |  |  |  |  |  | ARMIDALE | 1300 | Mdn | 00:01:16.650000
 |  |  |  |  |  |  |  |  |  |  |  | AVOCA | 1200 | BM52 | 00:01:13.750000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT | 1100 | Mdn | 00:01:06.890000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT | 1400 | Mdn | 00:01:30.300000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT | 1400 | BM64 | 00:01:25.450000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT | 1600 | BM64 | 00:01:41.300000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT | 3200 | Hrdle | 00:04:03.900000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT | 3200 | Mhdle | 00:04:03.870000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT SYNTHETIC | 1400 | Mdn | 00:01:25.730000
 |  |  |  |  |  |  |  |  |  |  |  | BALLARAT SYNTHETIC | 2100 | BM58 | 00:02:14.500000