Spreadsheet: 847366d1698327474-array-formula-or-solution-to-make-data-power-bi-compatible-ce-trial
Sheet: Bulldozer

Type | Brand | Headquarters | Austria | Brazil | China | France | Germany | India | Indonesia | Italy | Japan | UK | USA |  | Type | Brand | Headquarters | Country |  |  |  |  |  |  |  |  |  |  |  |  | Type | Brand | Headquarters | Manufacturing Facility
Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA |  | True | True | True |  |  |  |  |  | True | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA | Brazil
Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan |  | True | True |  |  |  | True |  | True |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA | China
Crawler Bulldozer | [NAME] | Moline, Illinois, USA |  |  |  |  |  |  |  |  |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA | Czech
Crawler Bulldozer | Liebherr | Bulle, Switzerland | True | True | True |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA | France
[NAME] | Komatsu | Minato, Tokyo, Japan |  | True | True |  |  |  | True |  | True |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA | Germany
[NAME] | [NAME] | Moline, Illinois, USA |  |  |  |  |  |  |  |  |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Caterpillar | Peoria, Illinois, USA | USA
[NAME] | Liebherr | Bulle, Switzerland | True | True | True |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Austria
Crawler Bulldozer | Case CE | Turin, Italy |  |  |  |  |  |  |  | True |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Belgium
Crawler Bulldozer | JCB | UK |  |  |  |  |  | True |  |  |  | True | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Brazil
[NAME] | LiuGong Machinery | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Canada
Crawler Bulldozer | LiuGong Machinery | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | China
[NAME] | [NAME] | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Czech
Crawler Bulldozer | [NAME] | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Germany
Crawler Bulldozer | New Holland | Turin, Italy |  |  | True |  |  |  |  | True |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | India
[NAME] | Zoomlion | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Indonesia
Crawler Bulldozer | Zoomlion | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Italy
[NAME] | Sinomach-HI | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Japan
Crawler Bulldozer | Sinomach-HI | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Korea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Mexico
Crawler Bulldozer | XGMA | China |  |  | True |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Middle East
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Netherlands
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Poland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Spain
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Sweden
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | Swiss
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | UK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Komatsu | Minato, Tokyo, Japan | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | [NAME] | Moline, Illinois, USA | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Africa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Austria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Belgium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Brazil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Canada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | China
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Czech
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | France
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | Germany
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Liebherr | Bulle, Switzerland | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Austria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Belgium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Brazil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Canada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | China
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Czech
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Germany
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | India
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Indonesia
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Italy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Japan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Korea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Mexico
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Middle East
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Netherlands
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Poland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Spain
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Sweden
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | Swiss
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | UK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Komatsu | Minato, Tokyo, Japan | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | Moline, Illinois, USA | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Africa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Austria
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Belgium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Brazil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Canada
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | China
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Czech
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | France
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | Germany
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Liebherr | Bulle, Switzerland | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Case CE | Turin, Italy | China
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Case CE | Turin, Italy | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | JCB | UK | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | LiuGong Machinery | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | LiuGong Machinery | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | [NAME] | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | Brazil
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | China
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | Czech
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | France
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | Germany
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | India
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | Italy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | UK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | New Holland | Turin, Italy | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Zoomlion | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Zoomlion | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Sinomach-HI | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | Sinomach-HI | China | USA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crawler Bulldozer | XGMA | China | USA