Spreadsheet: 146424d1332178599-sorting-issue-for-large-event-copy-of-participant_registration_example
Sheet: Sheet1

LAST_NAME | FIRST_NAME | [NAME] | ADDRESS_2 | CITY | STATE | ZIP | Final Order for Household | t-shirt size |  | Full Address | Sequence | Concat 1 | Total Shirt Order | # of Members per Household | Concat 2
Abbysinian | Christy | 1 Ackerman Court |  | Blairstown | NJ | 6623 | [NAME] | [NAME] |  | 1 Ackerman CourtBlairstownNJ6623 | 1 | 1 Ackerman CourtBlairstownNJ6623---1 | [NAME] | 1 | 1 Ackerman CourtBlairstownNJ6623---1
Aarons | [NAME] | 1 [NAME] |  | Bronxville | NY | 10555 | [NAME] | [NAME] |  | 1 Alexander St #320BronxvilleNY10555 | 1 | 1 Alexander St #320BronxvilleNY10555---1 | [NAME] | 1 | 1 Alexander St #320BronxvilleNY10555---1
[NAME] | [NAME] | 1 Cavelo Rd |  | Hopewell Junction | NY | 3515 | [NAME] | [NAME] |  | 1 [NAME] JunctionNY3515 | 1 | 1 [NAME] | [NAME] | 1 | 1 [NAME]
Adorno | Christine | 1 Hammerstein Place | Apt U7J | New York | NY | 9912 | [NAME] | [NAME] |  | 1 Hammerstein PlaceApt U7JNew YorkNY9912 | 1 | 1 Hammerstein PlaceApt U7JNew YorkNY9912---1 | [NAME] | 1 | 1 Hammerstein PlaceApt U7JNew YorkNY9912---1
Addonisio | [NAME] | 1 Hudson Terrace | Unit B | Dobbs [NAME] | NY | 3311 | Youth Large | Youth Large |  | 1 Hudson TerraceUnit BDobbs FerryNY3311 | 1 | 1 Hudson TerraceUnit BDobbs FerryNY3311---1 | Youth Large | 1 | 1 Hudson TerraceUnit BDobbs FerryNY3311---1
Aggarwal | [NAME] | 1 Locust Lane | Apt B-1Q | [NAME] | NY | 8621 | [NAME] | [NAME] |  | 1 Locust LaneApt B-1QCarle PlaceNY8621 | 1 | 1 Locust LaneApt B-1QCarle PlaceNY8621---1 | [NAME] | 1 | 1 Locust LaneApt B-1QCarle PlaceNY8621---1
Agate | KellieAnne | 1 Nortel Circle |  | West Orange | NJ | 6312 | [NAME] | [NAME] |  | 1 Nortel CircleWest OrangeNJ6312 | 1 | 1 Nortel CircleWest OrangeNJ6312---1 | [NAME] | 1 | 1 Nortel CircleWest OrangeNJ6312---1
Ackermann | Candice | 1 Precise Tpke |  | Middletown | NY | 1818 | [NAME] | [NAME] |  | 1 Precise TpkeMiddletownNY1818 | 1 | 1 Precise TpkeMiddletownNY1818---1 | [NAME] | 1 | 1 Precise TpkeMiddletownNY1818---1
Abriss | [NAME] | 1 Tomkins drive apt 3c |  | Fishkill | NY | 1287 | [NAME] | [NAME] |  | 1 Tomkins drive apt 3cFishkillNY1287 | 1 | 1 Tomkins drive apt 3cFishkillNY1287---1 | [NAME] | 1 | 1 Tomkins drive apt 3cFishkillNY1287---1
[NAME] | Victoria | 1 Whitewall Court |  | Brooklyn | NY | 7733 | [NAME] | [NAME] |  | 1 Whitewall CourtBrooklynNY7733 | 1 | 1 Whitewall CourtBrooklynNY7733---1 | [NAME] | 1 | 1 Whitewall CourtBrooklynNY7733---1
Adams | [NAME] | 12 Harwood Pl |  | Danville | NJ | 9090 | [NAME], Youth Large | [NAME] |  | 12 Harwood PlDanvilleNJ9090 | 1 | 12 Harwood PlDanvilleNJ9090---1 | [NAME] | 2 | 12 Harwood PlDanvilleNJ9090---2
Adams | [NAME] | 12 Harwood Pl |  | Danville | NJ | 9090 | [NAME], Youth Large | Youth Large |  | 12 Harwood PlDanvilleNJ9090 | 2 | 12 Harwood PlDanvilleNJ9090---2 | [NAME], Youth Large | 2 | 12 Harwood PlDanvilleNJ9090---2
Adams | Lauren | 17 HUDSON TER UNIT B | Unit B | Hartsdale | CT | 1100 | [NAME], [NAME] | [NAME] |  | 17 HUDSON TER UNIT BUnit BHartsdaleCT1100 | 1 | 17 HUDSON TER UNIT [NAME] | [NAME] | 2 | 17 HUDSON TER UNIT [NAME]
Adams | Monique | 17 HUDSON TER UNIT B | Unit B | Hartsdale | CT | 1100 | [NAME], [NAME] | [NAME] |  | 17 HUDSON TER UNIT BUnit BHartsdaleCT1100 | 2 | 17 HUDSON TER UNIT [NAME] | [NAME], [NAME] | 2 | 17 HUDSON TER UNIT [NAME]
abel | Talia | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME], Adult Medium, Adult Extra Large | [NAME] |  | 40 Carey DriveBedfortNJ5445 | 1 | 40 [NAME] DriveBedfortNJ5445---1 | [NAME] | 3 | 40 [NAME] DriveBedfortNJ5445---3
Abitante | [NAME] | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME], Adult Medium, Adult Extra Large | [NAME] |  | 40 Carey DriveBedfortNJ5445 | 2 | 40 [NAME] DriveBedfortNJ5445---2 | [NAME], Adult Medium | 3 | 40 [NAME] DriveBedfortNJ5445---3
Abrahamson | Sara | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME], Adult Medium, Adult Extra Large | [NAME] |  | 40 Carey DriveBedfortNJ5445 | 3 | 40 [NAME] DriveBedfortNJ5445---3 | [NAME], Adult Medium, Adult Extra Large | 3 | 40 [NAME] DriveBedfortNJ5445---3
Adelfio | Athena | 45 Independence Court | Apt 216 | Eastchester | NJ | 7888 | [NAME], Adult Medium | [NAME] |  | 45 Independence CourtApt 216EastchesterNJ7888 | 1 | 45 Independence CourtApt 216EastchesterNJ7888---1 | [NAME] | 2 | 45 Independence CourtApt 216EastchesterNJ7888---2
Adin | [NAME] | 45 Independence Court | Apt 216 | Eastchester | NJ | 7888 | [NAME], Adult Medium | [NAME] |  | 45 Independence CourtApt 216EastchesterNJ7888 | 2 | 45 Independence CourtApt 216EastchesterNJ7888---2 | [NAME], Adult Medium | 2 | 45 Independence CourtApt 216EastchesterNJ7888---2
 |  | After you enter all the data you need, simply copy the values from ADDRESS_1 up to "Final Order for Household" to somewhere on this sheet (ex. right below here).
 |  | Then remove duplicates.
 |  | Using the sample data, you get:
 |  | [NAME] | ADDRESS_2 | CITY | STATE | ZIP | Final Order for Household
 |  | 1 Ackerman Court |  | Blairstown | NJ | 6623 | [NAME]
 |  | 1 [NAME] |  | Bronxville | NY | 10555 | [NAME]
 |  | 1 Cavelo Rd |  | Hopewell Junction | NY | 3515 | [NAME]
 |  | 1 Hammerstein Place | Apt U7J | New York | NY | 9912 | [NAME]
 |  | 1 Hudson Terrace | Unit B | Dobbs [NAME] | NY | 3311 | Youth Large
 |  | 1 Locust Lane | Apt B-1Q | [NAME] | NY | 8621 | [NAME]
 |  | 1 Nortel Circle |  | West Orange | NJ | 6312 | [NAME]
 |  | 1 Precise Tpke |  | Middletown | NY | 1818 | [NAME]
 |  | 1 Tomkins drive apt 3c |  | Fishkill | NY | 1287 | [NAME]
 |  | 1 Whitewall Court |  | Brooklyn | NY | 7733 | [NAME]
 |  | 12 Harwood Pl |  | Danville | NJ | 9090 | [NAME], Youth Large
 |  | 17 HUDSON TER UNIT B | Unit B | Hartsdale | CT | 1100 | [NAME], [NAME]
 |  | 40 [NAME] |  | Bedfort | NJ | 5445 | [NAME], Adult Medium, Adult Extra Large
 |  | 45 Independence Court | Apt 216 | Eastchester | NJ | 7888 | [NAME], Adult Medium