Spreadsheet: 748510d1632178043-i-need-a-formula-to-group-cells-that-are-on-different-rows-together-on-a-list-with-no-gap-book1
Sheet: TEST

 | VICKY COTTRELL |  | [NAME] | Albuquerque
 | BRANDON ROSQUITA |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME]
 | ANDY SICK |  | [NAME] | Alpharetta
 | [NAME] |  | [NAME] | Anaheim
 | PAUL DEWALD |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Arlington
 | PAUL DEWALD |  | [NAME] | Arundel Mills
 | DONNIE WATSON |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Aventura
 | PAUL DEWALD |  | [NAME] | Baltimore
 | DONNIE WATSON |  | [NAME] | Barton Creek
 | [NAME] |  | [NAME] | Bay Shore
 | [NAME] |  | [NAME] | Baybrook
 | BRANDON ROSQUITA |  | [NAME] | Bellevue
 | [NAME] |  | [NAME] | Beverly Hills
 | ANDY SICK |  | [NAME] | Birmingham
 | CINDY SARAVIA |  | [NAME] | [NAME]
 | KERRY KAYA |  | [NAME] | Boise
 | COREY DUGAN |  | [NAME] | Boston
 | COREY DUGAN |  | [NAME] | Braintree
 | [NAME] |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Brea
 | BRAD STEVENS |  | [NAME] | Bridgewater
 | DAVE LARSON |  | [NAME] | Buffalo
 | COREY DUGAN |  | [NAME] | Burlington
 | COREY DUGAN |  | [NAME] | Cambridge
 | [NAME] FUSCO |  | [NAME] | Carlsbad
 | [NAME] |  | [NAME] | Cerritos
 | VICKY COTTRELL |  | [NAME] | [NAME]
 | DYLAN CHASE |  | [NAME] | Charlotte
 | ANDY SICK |  | [NAME] | Chattanooga
 | ALPHONSO RIDDICK |  | [NAME] | [NAME]
 | SCOTT LUCIDO |  | [NAME] | Chesterfield
 | COREY DUGAN |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Chicago
 | ALPHONSO RIDDICK |  | [NAME] | Christiana
 | [NAME] FUSCO |  | [NAME] | [NAME]
 | [NAME] |  | Hayden Inniss | Cincinnati
 | KERRY KAYA |  | [NAME] | City Creek Center
 | BRANDON ROSQUITA |  | [NAME] | Clackamas
 | [NAME] |  | [NAME] | Clearwater
 | DAVE LARSON |  | [NAME] | Cleveland
 | PAUL DEWALD |  | [NAME] | Columbia
 | DAVE LARSON |  | Hayden Inniss | Columbus
 | [NAME] |  | [NAME] | Coolsprings
 | [NAME] |  | [NAME] | Coral Gables
 | [NAME] |  | [NAME] | [NAME]
 | ANDY SICK |  | [NAME] | Cumberland
 | [NAME] |  | [NAME] | Dadeland
 | [NAME] |  | [NAME] | Dallas
 | JIMMY ZAZZARO |  | [NAME] | Danbury
 | [NAME] |  | Hayden Inniss | Dayton
 | [NAME] |  | [NAME] | Denver
 | SCOTT LUCIDO |  | [NAME] | Des Moines
 | [NAME] |  | [NAME] | Dolphin Mall
 | [NAME] |  | [NAME] | Dulles
 | DYLAN CHASE |  | [NAME] | [NAME]
 | SCOTT LUCIDO |  | [NAME] | Edina
 | ALPHONSO RIDDICK |  | [NAME] | Edison
 | [NAME] FUSCO |  | [NAME] | Escondido
 | [NAME] |  | [NAME] | Fairfax
 | CINDY SARAVIA |  | [NAME] | Fort Lauderdale
 | [NAME] |  | [NAME] | Fort Worth
 | BRAD STEVENS |  | [NAME] | Freehold
 | KERRY KAYA |  | [NAME] | Fresno
 | [NAME] |  | [NAME] | Gainesville
 | [NAME] |  | [NAME] | Glendale
 | BRAD STEVENS |  | [NAME] | Grand Rapids
 | DYLAN CHASE |  | [NAME] | Greensboro
 | DYLAN CHASE |  | [NAME] | Greenville
 | [NAME] |  | Hayden Inniss | [NAME]
 | JIMMY ZAZZARO |  | [NAME] | Hackensack
 | [NAME] |  | [NAME] | Henderson
 | [NAME] |  | [NAME] | Hillsdale
 | [NAME] FUSCO |  | [NAME] | Honolulu
 | [NAME] |  | [NAME] | Houston
 | [NAME] |  | [NAME] | Huntington Beach
 | [NAME] |  | [NAME] | [NAME]
 | ANDY SICK |  | [NAME] | Huntsville
 | [NAME] |  | Hayden Inniss | Indianapolis
 | [NAME] |  | [NAME] | [NAME]
 | CINDY SARAVIA |  | [NAME] | Jacksonville
 | BRAD STEVENS |  | [NAME] | Jersey City
 | SCOTT LUCIDO |  | [NAME] | Kansas City
 | [NAME] FUSCO |  | [NAME] | Kapolei
 | ALPHONSO RIDDICK |  | [NAME] | King Of Prussia
 | DYLAN CHASE |  | [NAME] | Knoxville
 | DONNIE WATSON |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Lake Grove
 | [NAME] |  | [NAME] | Las Vegas
 | ANDY SICK |  | [NAME] | Lenox Square Mall
 | [NAME] |  | Hayden Inniss | Lexington
 | [NAME] |  | Hayden Inniss | Liberty Center Cincinnati
 | [NAME] |  | [NAME] | Lincolnshire
 | [NAME] |  | [NAME] | Littleton
 | [NAME] |  | Hayden Inniss | Louisville
 | DONNIE WATSON |  | [NAME] | Lubbock
 | SCOTT LUCIDO |  | [NAME] | [NAME]
 | ANDY SICK |  | [NAME] | Mall Of Georgia
 | [NAME] |  | [NAME] | Marina Del Rey
 | [NAME] |  | [NAME] | Memorial City
 | DONNIE WATSON |  | [NAME] | Memphis-Wolfchase
 | VICKY COTTRELL |  | [NAME] | Mesa
 | DONNIE WATSON |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Milwaukee
 | SCOTT LUCIDO |  | [NAME] | Minnetonka
 | [NAME] |  | [NAME] | Mission Viejo
 | [NAME] |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Naples
 | [NAME] |  | [NAME] | Nashville
 | COREY DUGAN |  | [NAME] | Natick
 | [NAME] |  | [NAME] | Newport Beach
 | [NAME] |  | [NAME] | North Las Vegas
 | COREY DUGAN |  | [NAME] | North Shore
 | [NAME] |  | [NAME] | Oakbrook
 | [NAME] |  | [NAME] | Oklahoma City
 | [NAME] |  | [NAME] | Old Orchard
 | DONNIE WATSON |  | [NAME] | Omaha
 | [NAME] |  | [NAME] | Orland Park
 | [NAME] |  | [NAME] | Orlando
 | [NAME] |  | [NAME] | Orlando Vineland
 | SCOTT LUCIDO |  | [NAME] | Overland Park
 | [NAME] |  | [NAME] | Oxnard
 | CINDY SARAVIA |  | [NAME] | Palm Beach Gardens
 | [NAME] |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | [NAME] At Arlington
 | [NAME] |  | [NAME] | Pasadena
 | [NAME] |  | [NAME] | Pembroke Pines
 | VICKY COTTRELL |  | [NAME] | Peoria
 | ANDY SICK |  | [NAME] | Perimeter
 | ALPHONSO RIDDICK |  | [NAME] | Philadelphia
 | VICKY COTTRELL |  | [NAME] | Phoenix
 | DAVE LARSON |  | [NAME] | Pittsburgh
 | KERRY KAYA |  | [NAME] | Pleasanton
 | DAVE LARSON |  | Hayden Inniss | [NAME]
 | PAUL DEWALD |  | [NAME] | Potomac Mills
 | COREY DUGAN |  | [NAME] | Providence
 | ALPHONSO RIDDICK |  | [NAME] | Quaker Bridge
 | [NAME] |  | [NAME] | Queens
 | DYLAN CHASE |  | [NAME] | Raleigh
 | [NAME] |  | [NAME] | Rancho Cucamonga
 | [NAME] FUSCO |  | [NAME] | Rancho Mirage
 | [NAME] |  | [NAME] | Redondo Beach
 | [NAME] |  | [NAME] | Reno
 | PAUL DEWALD |  | [NAME] | Richmond
 | JIMMY ZAZZARO |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Riverside
 | [NAME] |  | [NAME] | Rochester
 | BRAD STEVENS |  | [NAME] | Rockaway
 | KERRY KAYA |  | [NAME] | Roseville
 | DAVE LARSON |  | [NAME] | [NAME]
 | KERRY KAYA |  | [NAME] | Sacramento
 | KERRY KAYA |  | [NAME] | Salt Lake City
 | DONNIE WATSON |  | [NAME] | San Antonio
 | [NAME] FUSCO |  | [NAME] | San Diego
 | [NAME] |  | [NAME] | San Francisco
 | [NAME] |  | [NAME] | San Jose
 | CINDY SARAVIA |  | [NAME] | San Juan
 | [NAME] |  | [NAME] | Santa Anita
 | [NAME] |  | [NAME] | Santa Monica
 | [NAME] |  | [NAME] | Sarasota
 | CINDY SARAVIA |  | [NAME] | Sawgrass Mills
 | [NAME] |  | [NAME] | Schaumburg
 | VICKY COTTRELL |  | [NAME] | Scottsdale
 | BRANDON ROSQUITA |  | [NAME] | Seattle
 | [NAME] |  | [NAME] | [NAME]
 | BRAD STEVENS |  | [NAME] | Short Hills
 | BRANDON ROSQUITA |  | [NAME] | South Center
 | [NAME] |  | [NAME] | South San Jose
 | [NAME] |  | [NAME] | Southlake
 | SCOTT LUCIDO |  | [NAME] | St. Louis
 | [NAME] |  | [NAME] | Stonebriar
 | [NAME] |  | [NAME] | Sugar Land
 | [NAME] |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Syracuse
 | BRANDON ROSQUITA |  | [NAME] | Tacoma
 | [NAME] |  | [NAME] | Tampa
 | [NAME] |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | The Grove
 | [NAME] FUSCO |  | [NAME] | The Headquarters
 | [NAME] |  | [NAME] | The Woodlands
 | [NAME] |  | [NAME] | Thousand Oaks
 | BRANDON ROSQUITA |  | [NAME] | Tigard
 | [NAME] |  | [NAME] | Topanga
 | PAUL DEWALD |  | [NAME] | Towson
 | JIMMY ZAZZARO |  | [NAME] | Trumbull
 | VICKY COTTRELL |  | [NAME] | Tucson
 | [NAME] |  | [NAME] | Tulsa
 | BRAD STEVENS |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Tyson'S Corner
 | [NAME] |  | [NAME] | [NAME]
 | DYLAN CHASE |  | [NAME] | Virginia Beach
 | KERRY KAYA |  | [NAME] | Walnut Creek
 | [NAME] |  | [NAME] | Washington D.C.
 | [NAME] |  | [NAME] | Washington Dc Downtown
 | [NAME] |  | [NAME] | Wauwatosa
 | JIMMY ZAZZARO |  | [NAME] | West Hartford
 | JIMMY ZAZZARO |  | [NAME] | West Nyack
 | CINDY SARAVIA |  | [NAME] | West Palm Beach
 | [NAME] |  | [NAME] | Westbury
 | DAVE LARSON |  | [NAME] | Westlake
 | JIMMY ZAZZARO |  | [NAME] | White Plains
 | ALPHONSO RIDDICK |  | [NAME] | Willow Grove
 | BRAD STEVENS |  | [NAME] | [NAME]
 | [NAME] |  | [NAME] | Winter Park
 | DAVE LARSON |  | [NAME] | Yorkdale - Toronto
 | TIM CREEDON |  | [NAME]
 | [NAME] |  | [NAME]
 | DYLAN CHASE |  | [NAME]
 | JIMMY ZAZZARO |  | [NAME]
 | CINDY SARAVIA |  | [NAME]
 | [NAME]
 | [NAME]
 | [NAME] FUSCO
 | SHANNON VENTURO
 | ANDY SICK