Spreadsheet: 824772d1680811599-looking-for-formula-to-return-array-of-data-excluding-blank-cells-test-deliverables
Sheet: Formula Central

Annual Tasks | Frequency | Annual Dates | Semi-Annual Tasks | Frequency | Semi-Annual Dates | Quarterly Tasks | Frequency | Quarterly Dates | Monthly Tasks | Frequency | Monthly Dates |  | Combo Tasks | Frequency | [NAME] |  |  |  |  |  | Combo Tasks | Frequency | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holidays | When | Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00