Spreadsheet: 842144d1694192785-formula-to-generate-array-base-on-whether-user-indicate-a-tick-on-header-specific-column
Sheet: Data

Date | Invoice No | [NAME] | Customer Name | Product | Region | GL Code | Invoice Amt | GL Descripton | Tax Code
2023-02-02 00:00:00 | Inv#03-110 | [NAME] | Abc | Toy | PAC | 01-001 | 11041 | Sales | No Tax |  |  | a
2023-02-02 00:00:00 | Inv#03-111 | Kelly | Def | Food | ITA | 01-001 | 9603 | Sales | No Tax |  | Def | a
2023-02-07 00:00:00 | Inv#03-112 | Michelle | [NAME] | Service | CHN | 01-001 | 10624 | Sales | GST |  | Ggg
2023-02-07 00:00:00 | Inv#03-113 | Kelly | Ggg | Toy | DEU | 01-002 | 10605 | Sales-3rd Party | No Tax |  | [NAME]
2023-02-07 00:00:00 | Inv#03-114 | Julian | xyz | Food | PAC | 01-003 | 10290 | Sales-Interco | No Tax |  | xyz | a
2023-02-07 00:00:00 | Inv#03-115 | Yvonne | zzz | Service | ITA | 01-001 | 11241 | Sales | GST |  | zzz
2023-02-07 00:00:00 | Inv#03-116 | [NAME] | Abc | Toy | CHN | 01-001 | 11858 | Sales | No Tax
2023-02-07 00:00:00 | Inv#03-117 | Kelly | Def | Food | DEU | 01-001 | 10352 | Sales | No Tax
2023-02-14 00:00:00 | Inv#03-118 | Michelle | [NAME] | Service | PAC | 01-002 | 10099 | Sales-3rd Party | GST
2023-02-14 00:00:00 | Inv#03-119 | Kelly | Ggg | Toy | ITA | 01-003 | 10256 | Sales-Interco | No Tax
2023-02-14 00:00:00 | Inv#03-120 | Julian | xyz | Food | CHN | 01-004 | 10481 | Sales-MD | No Tax
2023-02-14 00:00:00 | Inv#03-121 | Yvonne | zzz | Service | DEU | 01-001 | 10779 | Sales | GST
2023-02-14 00:00:00 | Inv#03-122 | [NAME] | Abc | Toy | PAC | 01-001 | 10329 | Sales | No Tax
2023-02-14 00:00:00 | Inv#03-123 | Kelly | Def | Food | ITA | 01-001 | 11204 | Sales | No Tax
2023-02-14 00:00:00 | Inv#03-124 | Michelle | [NAME] | Service | CHN | 01-003 | 9899 | Sales-Interco | GST
2023-02-14 00:00:00 | Inv#03-125 | Kelly | Ggg | Toy | DEU | 01-002 | 11989 | Sales-3rd Party | No Tax
2023-02-14 00:00:00 | Inv#03-126 | Julian | xyz | Food | PAC | 01-002 | 9707 | Sales-3rd Party | No Tax
2023-02-14 00:00:00 | Inv#03-127 | Yvonne | zzz | Service | ITA | 01-002 | 11363 | Sales-3rd Party | GST |  |  | is it possible to Combine this as well?
2023-02-14 00:00:00 | Inv#03-128 | Michelle | Abc | Toy | CHN | 01-003 | 10317 | Sales-Interco | No Tax
2023-02-14 00:00:00 | Inv#03-129 | Kelly | Def | Food | DEU | 01-003 | 11373 | Sales-Interco | No Tax
2023-02-14 00:00:00 | Inv#03-130 | Michelle | [NAME] | Service | PAC | 01-003 | 11556 | Sales-Interco | GST
2023-02-14 00:00:00 | Inv#03-131 | Kelly | Ggg | Toy | ITA | 01-004 | 9836 | Sales-MD | No Tax
*Issit to have a formula to show onli Column indicated with a tick as below?
 |  |  | Desired Result
Header | [NAME] |  | Date | Invoice No | [NAME] | Product |  |  | Invoice No | [NAME] | Product
 | a |  | 2023-02-02 00:00:00 | Inv#03-110 | [NAME] | Toy |  | 2023-02-02 00:00:00 | Inv#03-110 | [NAME] | Toy
Invoice No | a |  | 2023-02-02 00:00:00 | Inv#03-111 | Kelly | Food |  | 2023-02-02 00:00:00 | Inv#03-111 | Kelly | Food
[NAME] | a |  | 2023-02-07 00:00:00 | Inv#03-112 | Michelle | Service |  | 2023-02-07 00:00:00 | Inv#03-114 | Julian | Food
Customer Name |  |  | 2023-02-07 00:00:00 | Inv#03-113 | Kelly | Toy |  | 2023-02-07 00:00:00 | Inv#03-116 | [NAME] | Toy
Product | a |  | 2023-02-07 00:00:00 | Inv#03-114 | Julian | Food |  | 2023-02-07 00:00:00 | Inv#03-117 | Kelly | Food
Region |  |  | 2023-02-07 00:00:00 | Inv#03-115 | Yvonne | Service |  | 2023-02-14 00:00:00 | Inv#03-120 | Julian | Food
GL Code |  |  | 2023-02-07 00:00:00 | Inv#03-116 | [NAME] | Toy |  | 2023-02-14 00:00:00 | Inv#03-122 | [NAME] | Toy
Invoice Amt |  |  | 2023-02-07 00:00:00 | Inv#03-117 | Kelly | Food |  | 2023-02-14 00:00:00 | Inv#03-123 | Kelly | Food
GL Descripton |  |  | 2023-02-14 00:00:00 | Inv#03-118 | Michelle | Service |  | 2023-02-14 00:00:00 | Inv#03-126 | Julian | Food
Tax Code |  |  | 2023-02-14 00:00:00 | Inv#03-119 | Kelly | Toy |  | 2023-02-14 00:00:00 | Inv#03-128 | Michelle | Toy
 |  |  | 2023-02-14 00:00:00 | Inv#03-120 | Julian | Food |  | 2023-02-14 00:00:00 | Inv#03-129 | Kelly | Food
 |  |  | 2023-02-14 00:00:00 | Inv#03-121 | Yvonne | Service
 |  |  | 2023-02-14 00:00:00 | Inv#03-122 | [NAME] | Toy
 |  |  | 2023-02-14 00:00:00 | Inv#03-123 | Kelly | Food
 |  |  | 2023-02-14 00:00:00 | Inv#03-124 | Michelle | Service
 |  |  | 2023-02-14 00:00:00 | Inv#03-125 | Kelly | Toy
 |  |  | 2023-02-14 00:00:00 | Inv#03-126 | Julian | Food
 |  |  | 2023-02-14 00:00:00 | Inv#03-127 | Yvonne | Service
 |  |  | 2023-02-14 00:00:00 | Inv#03-128 | Michelle | Toy
 |  |  | 2023-02-14 00:00:00 | Inv#03-129 | Kelly | Food
 |  |  | 2023-02-14 00:00:00 | Inv#03-130 | Michelle | Service
 |  |  | 2023-02-14 00:00:00 | Inv#03-131 | Kelly | Toy