Spreadsheet: 748508d1632176994-i-need-a-formula-to-group-cells-that-are-on-different-rows-together-on-a-list-with-no-gap-book1
Sheet: sheet

 |  | [NAME] | Albany |  | How do I get these locations listed TOGETHER IN COLUMN?
 |  | [NAME] | Albuquerque
 |  | [NAME] | [NAME] |  |  | LIKE THIS
 |  | [NAME] | [NAME] |  |  | Locatons 1
 |  | [NAME] | Alpharetta |  |  | Locatons 2
 |  | [NAME] | Anaheim |  |  | Locatons 3
 |  | [NAME] | [NAME] |  |  | Locatons 4
 |  | [NAME] | Arlington |  |  | Locatons 5
 |  | [NAME] | Arundel Mills |  |  | Locatons 6
 |  | [NAME] | [NAME] |  |  | Locatons 7
 |  | [NAME] | Aventura |  |  | Locatons 8
 |  | [NAME] | Baltimore | NOT THIS Seprated |  | Locatons 9
 |  | [NAME] | Barton Creek
 |  | [NAME] | Bay Shore
 |  | [NAME] | Baybrook
 |  | [NAME] | Bellevue
 |  | [NAME] | Beverly Hills
 |  | [NAME] | Birmingham
 |  | [NAME] | [NAME]
 |  | [NAME] | Boise
 |  | [NAME] | Boston
 |  | [NAME] | Braintree
 |  | [NAME] | [NAME]
 |  | [NAME] | Brea
 |  | [NAME] | Bridgewater
 |  | [NAME] | Buffalo
 |  | [NAME] | Burlington
 |  | [NAME] | Cambridge
 |  | [NAME] | Carlsbad
 |  | [NAME] | Cerritos
 |  | [NAME] | [NAME]
 |  | [NAME] | Charlotte
 |  | [NAME] | Chattanooga
 |  | [NAME] | [NAME]
 |  | [NAME] | Chesterfield
 |  | [NAME] | [NAME]
 |  | [NAME] | Chicago
 |  | [NAME] | Christiana
 |  | [NAME] | [NAME]
 |  | Hayden Inniss | Cincinnati
 |  | [NAME] | City Creek Center
 |  | [NAME] | Clackamas
 |  | [NAME] | Clearwater
 |  | [NAME] | Cleveland
 |  | [NAME] | Columbia
 |  | Hayden Inniss | Columbus
 |  | [NAME] | Coolsprings
 |  | [NAME] | Coral Gables
 |  | [NAME] | [NAME]
 |  | [NAME] | Cumberland
 |  | [NAME] | Dadeland
 |  | [NAME] | Dallas
 |  | [NAME] | Danbury
 |  | Hayden Inniss | Dayton
 |  | [NAME] | Denver
 |  | [NAME] | Des Moines
 |  | [NAME] | Dolphin Mall
 |  | [NAME] | Dulles
 |  | [NAME] | [NAME]
 |  | [NAME] | Edina
 |  | [NAME] | Edison
 |  | [NAME] | Escondido
 |  | [NAME] | Fairfax
 |  | [NAME] | Fort Lauderdale
 |  | [NAME] | Fort Worth
 |  | [NAME] | Freehold
 |  | [NAME] | Fresno
 |  | [NAME] | Gainesville
 |  | [NAME] | Glendale
 |  | [NAME] | Grand Rapids
 |  | [NAME] | Greensboro
 |  | [NAME] | Greenville
 |  | Hayden Inniss | [NAME]
 |  | [NAME] | Hackensack
 |  | [NAME] | Henderson
 |  | [NAME] | Hillsdale
 |  | [NAME] | Honolulu
 |  | [NAME] | Houston
 |  | [NAME] | Huntington Beach
 |  | [NAME] | [NAME]
 |  | [NAME] | Huntsville
 |  | Hayden Inniss | Indianapolis
 |  | [NAME] | [NAME]
 |  | [NAME] | Jacksonville
 |  | [NAME] | Jersey City
 |  | [NAME] | Kansas City
 |  | [NAME] | Kapolei
 |  | [NAME] | King Of Prussia
 |  | [NAME] | Knoxville
 |  | [NAME] | [NAME]
 |  | [NAME] | Lake Grove
 |  | [NAME] | Las Vegas
 |  | [NAME] | Lenox Square Mall
 |  | Hayden Inniss | Lexington
 |  | Hayden Inniss | Liberty Center Cincinnati
 |  | [NAME] | Lincolnshire
 |  | [NAME] | Littleton
 |  | Hayden Inniss | Louisville
 |  | [NAME] | Lubbock
 |  | [NAME] | [NAME]
 |  | [NAME] | Mall Of Georgia
 |  | [NAME] | Marina Del Rey
 |  | [NAME] | Memorial City
 |  | [NAME] | Memphis-Wolfchase
 |  | [NAME] | Mesa
 |  | [NAME] | [NAME]
 |  | [NAME] | Milwaukee
 |  | [NAME] | Minnetonka
 |  | [NAME] | Mission Viejo
 |  | [NAME] | [NAME]
 |  | [NAME] | Naples
 |  | [NAME] | Nashville
 |  | [NAME] | Natick
 |  | [NAME] | Newport Beach
 |  | [NAME] | North Las Vegas
 |  | [NAME] | North Shore
 |  | [NAME] | Oakbrook
 |  | [NAME] | Oklahoma City
 |  | [NAME] | Old Orchard
 |  | [NAME] | Omaha
 |  | [NAME] | Orland Park
 |  | [NAME] | Orlando
 |  | [NAME] | Orlando Vineland
 |  | [NAME] | Overland Park
 |  | [NAME] | Oxnard
 |  | [NAME] | Palm Beach Gardens
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME] At Arlington
 |  | [NAME] | Pasadena
 |  | [NAME] | Pembroke Pines
 |  | [NAME] | Peoria
 |  | [NAME] | Perimeter
 |  | [NAME] | Philadelphia
 |  | [NAME] | Phoenix
 |  | [NAME] | Pittsburgh
 |  | [NAME] | Pleasanton
 |  | Hayden Inniss | [NAME]
 |  | [NAME] | Potomac Mills
 |  | [NAME] | Providence
 |  | [NAME] | Quaker Bridge
 |  | [NAME] | Queens
 |  | [NAME] | Raleigh
 |  | [NAME] | Rancho Cucamonga
 |  | [NAME] | Rancho Mirage
 |  | [NAME] | Redondo Beach
 |  | [NAME] | Reno
 |  | [NAME] | Richmond
 |  | [NAME] | [NAME]
 |  | [NAME] | Riverside
 |  | [NAME] | Rochester
 |  | [NAME] | Rockaway
 |  | [NAME] | Roseville
 |  | [NAME] | [NAME]
 |  | [NAME] | Sacramento
 |  | [NAME] | Salt Lake City
 |  | [NAME] | San Antonio
 |  | [NAME] | San Diego
 |  | [NAME] | San Francisco
 |  | [NAME] | San Jose
 |  | [NAME] | San Juan
 |  | [NAME] | Santa Anita
 |  | [NAME] | Santa Monica
 |  | [NAME] | Sarasota
 |  | [NAME] | Sawgrass Mills
 |  | [NAME] | Schaumburg
 |  | [NAME] | Scottsdale
 |  | [NAME] | Seattle
 |  | [NAME] | [NAME]
 |  | [NAME] | Short Hills
 |  | [NAME] | South Center
 |  | [NAME] | South San Jose
 |  | [NAME] | Southlake
 |  | [NAME] | St. Louis
 |  | [NAME] | Stonebriar
 |  | [NAME] | Sugar Land
 |  | [NAME] | [NAME]
 |  | [NAME] | Syracuse
 |  | [NAME] | Tacoma
 |  | [NAME] | Tampa
 |  | [NAME] | [NAME]
 |  | [NAME] | The Grove
 |  | [NAME] | The Headquarters
 |  | [NAME] | The Woodlands
 |  | [NAME] | Thousand Oaks
 |  | [NAME] | Tigard
 |  | [NAME] | Topanga
 |  | [NAME] | Towson
 |  | [NAME] | Trumbull
 |  | [NAME] | Tucson
 |  | [NAME] | Tulsa
 |  | [NAME] | [NAME]
 |  | [NAME] | Tyson'S Corner
 |  | [NAME] | [NAME]
 |  | [NAME] | Virginia Beach
 |  | [NAME] | Walnut Creek
 |  | [NAME] | Washington D.C.
 |  | [NAME] | Washington Dc Downtown
 |  | [NAME] | Wauwatosa
 |  | [NAME] | West Hartford
 |  | [NAME] | West Nyack
 |  | [NAME] | West Palm Beach
 |  | [NAME] | Westbury
 |  | [NAME] | Westlake
 |  | [NAME] | White Plains
 |  | [NAME] | Willow Grove
 |  | [NAME] | [NAME]
 |  | [NAME] | Winter Park
 |  | [NAME] | Yorkdale - Toronto
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]