Spreadsheet: 824715d1680788430-looking-for-formula-to-return-array-of-data-excluding-blank-cells-return-values
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 (No Blanks) | Frequency (No Blanks) | [NAME] (No Blanks) |  |  | Example of what I want it to look like
Reporting 1 | Annually | 2023-01-01 00:00:00 | Semi Reporting | Semi-Annually | 2023-05-01 00:00:00 | Quarterly 1 | Quarterly | 2023-04-03 00:00:00 | Monthly 1 | Monthly | 2023-02-01 00:00:00 |  |  |  |  |  | Holidays | When | Date |  |  |  |  |  |  | Reporting 1 | Annually | 2023-01-01 00:00:00
Reporting 2 | Annually | 2023-01-02 00:00:00 | 00:00:00 |  |  | Quarterly 2 | Quarterly | 2023-04-02 00:00:00 | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00 |  |  |  |  |  |  |  | Reporting 2 | Annually | 2023-01-02 00:00:00
Reporting 3 | Annually | 2023-01-03 00:00:00 | 00:00:00 |  |  | Quarterly 3 | Quarterly | 2023-04-03 00:00:00 | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January |  |  |  |  |  |  |  | Reporting 3 | Annually | 2023-01-03 00:00:00
Reporting 4 | Annually | 2023-01-04 00:00:00 | 00:00:00 |  |  | Quarterly 4 | Quarterly | 2023-04-04 00:00:00 | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February |  |  |  |  |  |  |  | Reporting 4 | Annually | 2023-01-04 00:00:00
Reporting 5 | Annually | 2023-01-08 00:00:00 | 00:00:00 |  |  | Quarterly 5 | Quarterly | 2023-04-05 00:00:00 | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May |  |  |  |  |  |  |  | Reporting 5 | Annually | 2023-01-08 00:00:00
Reporting 6 | Annually | 2023-01-08 00:00:00 | 00:00:00 |  |  | Quarterly 6 | Quarterly | 2023-04-09 00:00:00 | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th |  |  |  |  |  |  |  | Reporting 6 | Annually | 2023-01-08 00:00:00
Reporting 7 | Annually | 2023-01-09 00:00:00 | 00:00:00 |  |  | Quarterly 7 | Quarterly | 2023-04-09 00:00:00 | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00 |  |  |  |  |  |  |  | Reporting 7 | Annually | 2023-01-09 00:00:00
Reporting 8 | Annually | 2023-01-08 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September |  |  |  |  |  |  |  | Reporting 8 | Annually | 2023-01-08 00:00:00
Reporting 9 | Annually | 2023-01-09 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October |  |  |  |  |  |  |  | Reporting 9 | Annually | 2023-01-09 00:00:00
Reporting 10 | Annually | 2023-01-10 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00 |  |  |  |  |  |  |  | Reporting 10 | Annually | 2023-01-10 00:00:00
Reporting 11 | Annually | 2023-01-11 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November |  |  |  |  |  |  |  | Reporting 11 | Annually | 2023-01-11 00:00:00
Reporting 12 | Annually | 2023-01-15 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00 |  |  |  |  |  |  |  | Reporting 12 | Annually | 2023-01-15 00:00:00
Reporting 13 | Annually | 2023-01-15 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00 |  |  |  |  |  |  |  | Reporting 13 | Annually | 2023-01-15 00:00:00
Reporting 14 | Annually | 2023-01-16 00:00:00 | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January |  |  |  |  |  |  |  | Reporting 14 | Annually | 2023-01-16 00:00:00
 |  |  | Semi Reporting | Semi-Annually | 2023-11-02 00:00:00 | Quarterly 1 | Quarterly | 2023-10-04 00:00:00 | Monthly 1 | Monthly | 2023-08-02 00:00:00 |  |  |  |  |  | President's Day | The 3rd Monday in February |  |  |  |  |  |  |  | Semi Reporting | Semi-Annually | 2023-11-02 00:00:00
 |  |  | 00:00:00 |  |  | Quarterly 2 | Quarterly | 2023-10-03 00:00:00 | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May |  |  |  |  |  |  |  | Quarterly 1 | Quarterly | 2023-04-03 00:00:00
 |  |  | 00:00:00 |  |  | Quarterly 3 | Quarterly | 2023-10-04 00:00:00 | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th |  |  |  |  |  |  |  | Quarterly 2 | Quarterly | 2023-04-02 00:00:00
 |  |  | 00:00:00 |  |  | Quarterly 4 | Quarterly | 2023-10-05 00:00:00 | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00 |  |  |  |  |  |  |  | Quarterly 3 | Quarterly | 2023-04-03 00:00:00
 |  |  | 00:00:00 |  |  | Quarterly 5 | Quarterly | 2023-10-06 00:00:00 | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September |  |  |  |  |  |  |  | Quarterly 4 | Quarterly | 2023-04-04 00:00:00
 |  |  | 00:00:00 |  |  | Quarterly 6 | Quarterly | 2023-10-10 00:00:00 | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October |  |  |  |  |  |  |  | Quarterly 5 | Quarterly | 2023-04-05 00:00:00
 |  |  | 00:00:00 |  |  | Quarterly 7 | Quarterly | 2023-10-10 00:00:00 | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00 |  |  |  |  |  |  |  | Quarterly 6 | Quarterly | 2023-04-09 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November |  |  |  |  |  |  |  | Quarterly 7 | Quarterly | 2023-04-09 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00 |  |  |  |  |  |  |  | Quarterly 1 | Quarterly | 2023-10-04 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00 |  |  |  |  |  |  |  | Quarterly 2 | Quarterly | 2023-10-03 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January |  |  |  |  |  |  |  | Quarterly 3 | Quarterly | 2023-10-04 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February |  |  |  |  |  |  |  | Quarterly 4 | Quarterly | 2023-10-05 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May |  |  |  |  |  |  |  | Quarterly 5 | Quarterly | 2023-10-06 00:00:00
 |  |  | 00:00:00 |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th |  |  |  |  |  |  |  | Quarterly 6 | Quarterly | 2023-10-10 00:00:00
 |  |  |  |  |  | Quarterly 1 | Quarterly | 2024-04-05 00:00:00 | Monthly 1 | Monthly | 2024-02-05 00:00:00 |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00 |  |  |  |  |  |  |  | Quarterly 7 | Quarterly | 2023-10-10 00:00:00
 |  |  |  |  |  | Quarterly 2 | Quarterly | 2024-04-04 00:00:00 | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  | Quarterly 3 | Quarterly | 2024-04-05 00:00:00 | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  | Quarterly 4 | Quarterly | 2024-04-08 00:00:00 | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  | Quarterly 5 | Quarterly | 2024-04-08 00:00:00 | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  | Quarterly 6 | Quarterly | 2024-04-11 00:00:00 | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  | Quarterly 7 | Quarterly | 2024-04-11 00:00:00 | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  | Quarterly 1 | Quarterly | 2024-10-07 00:00:00 | Monthly 1 | Monthly | 2024-08-06 00:00:00 |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  | Quarterly 2 | Quarterly | 2024-10-07 00:00:00 | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  | Quarterly 3 | Quarterly | 2024-10-07 00:00:00 | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  | Quarterly 4 | Quarterly | 2024-10-09 00:00:00 | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  | Quarterly 5 | Quarterly | 2024-10-09 00:00:00 | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  | Quarterly 6 | Quarterly | 2024-10-14 00:00:00 | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  | Quarterly 7 | Quarterly | 2024-10-14 00:00:00 | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | Monthly 1 | Monthly | 2025-02-07 00:00:00 |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  | Monthly 1 | Monthly | 2025-08-08 00:00:00 |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  | Monthly 1 | Monthly | 2026-02-09 00:00:00 |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  | Monthly 1 | Monthly | 2026-08-10 00:00:00 |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | New Year's Day | 2023-01-01 00:00:00
 |  |  |  |  |  |  |  |  | Monthly 1 | Monthly | 2027-02-11 00:00:00 |  |  |  |  |  | [NAME] | The 3rd Monday in January
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | President's Day | The 3rd Monday in February
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Memorial Day | The last Monday in May
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Juneteenth | June 19th
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Independence Day | 2023-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Labor Day | The 1st Monday in September
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Columbus Day | The 2nd Monday in October
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Veteran's Day | 2023-11-11 00:00:00
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Thanksgiving Day | The 4th Thursday in November
 |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | Christmas Day | 2023-12-25 00:00:00
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0