Spreadsheet: 783262d1654695081-combining-multiple-records-with-unique-value-into-one-row-sample
Sheet: Output

[NAME] | RegularAddress1 | RegularAddress2 | RegularCity | RegularState | REgularZip | CONTACT_TYPE | CONTACT_ADDRESS_1 | CONTACT_ADDRESS_2 | CONTACT_ADDRESS_CITY | CONTACT_ADDRESS_STATE | CONTACT_ADDRESS_ZIP | Mailing1 | Mailing2 | MailingCity | MailingState | MailingZip | Shipping1 | Shipping2 | ShippingCity | ShippingState | ShippingZip
46344 | 608 Platte Road |  | Fairless Hills | PA | 19030 | Father | 608 Platte Road |  | Fairless Hills | PA | 19030 | 608 Platte Road |  | Fairless Hills | PA | 19030 | 608 Platte Road |  | Fairless Hills | PA | 19030
46344 | 608 Platte Road |  | Fairless Hills | PA | 19030 | Mother | 608 Platte Road |  | Fairless Hills | PA | 19030 | 608 Platte Road |  | Fairless Hills | PA | 19030 | 608 Platte Road |  | Fairless Hills | PA | 19030
80173 | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | _MailingAddress | PO Box 429 |  | [NAME] | PA | 16740 | PO Box 429 |  | [NAME] | PA | 16740 | 555 Anderson Street Extension |  | [NAME] | PA | 16740
80173 | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | Father | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | PO Box 429 |  | [NAME] | PA | 16740 | 555 Anderson Street Extension |  | [NAME] | PA | 16740
80173 | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | Mother | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | PO Box 429 |  | [NAME] | PA | 16740 | 555 Anderson Street Extension |  | [NAME] | PA | 16740
200082 | 123 Academy Road |  | Brownsville | PA | 15417 | _MailingAddress | PO Box 106 |  | Merrittstown | PA | 15463 | PO Box 106 |  | Merrittstown | PA | 15463 | 123 Academy Road |  | Brownsville | PA | 15417
200082 | 123 Academy Road |  | Brownsville | PA | 15417 | Father | 123 Academy Road |  | Merrittstown | PA | 15463 | PO Box 106 |  | Merrittstown | PA | 15463 | 123 Academy Road |  | Brownsville | PA | 15417
200082 | 123 Academy Road |  | Brownsville | PA | 15417 | Mother | 123 Academy Road |  | Merrittstown | PA | 15463 | PO Box 106 |  | Merrittstown | PA | 15463 | 123 Academy Road |  | Brownsville | PA | 15417
200246 | 102 Division Street |  | Portland | PA | 18351 | Father | 102 Division Street |  | Portland | PA | 18351 | 102 Division Street |  | Portland | PA | 18351 | 102 Division Street |  | Portland | PA | 18351
200246 | 102 Division Street |  | Portland | PA | 18351 | Mother | 102 Division Street |  | Portland | PA | 18351 | 102 Division Street |  | Portland | PA | 18351 | 102 Division Street |  | Portland | PA | 18351
306856 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | _MailingAddress | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301
306856 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | COA | 111 Aspen Circle | COA Pending | East Stroudsburg | PA | 18302 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301
306856 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | Father | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301
306856 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | Mother | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301 | 221 [NAME] | COA Pending | East Stroudsburg | PA | 18301
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | COA | 111 Aspen Circle |  | East Stroudsburg | PA | 18302 | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302 | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | Father | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302 | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | Mother | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302 | 2553 Lynnwood Drive | COA Pending | East Stroudsburg | PA | 18302
308438 | 112 Custer Avenue |  | Vandergrift | PA | 15690 | _MailingAddress | PO Box 4 |  |  | PA |  | PO Box 4 | COA Pending |  | PA |  | 112 Custer Avenue | COA Pending | Vandergrift | PA | 15690
308438 | 112 Custer Avenue |  | Vandergrift | PA | 15690 | COA | 128 Elder [NAME] |  | Leechburg | PA | 15656 | PO Box 4 | COA Pending |  | PA |  | 112 Custer Avenue | COA Pending | Vandergrift | PA | 15690
308438 | 112 Custer Avenue |  | Vandergrift | PA | 15690 | Mother | 112 Custer Avenue |  | Vandergrift | PA | 15690 | PO Box 4 | COA Pending |  | PA |  | 112 Custer Avenue | COA Pending | Vandergrift | PA | 15690
204561 | 5732 Chestnut Street |  | Philadelphia | PA | 19139 | COA | 6010 Cedarhurst Street |  | Philadelphia | PA | 19143 | [NAME] | COA Pending | Philadelphia | PA | 19139 | 5905 Cobbs Creek Parkway | COA Pending | Philadelphia | PA | 19149
204561 | 5732 Chestnut Street |  | Philadelphia | PA | 19139 | _MailingAddress | [NAME] |  | Philadelphia | PA | 19139 | [NAME] | COA Pending | Philadelphia | PA | 19139 | 5905 Cobbs Creek Parkway | COA Pending | Philadelphia | PA | 19149
204561 | 5732 Chestnut Street |  | Philadelphia | PA | 19139 | Other | 6010 Cedarhurst Street |  | Philadelphia | PA | 19143 | [NAME] | COA Pending | Philadelphia | PA | 19139 | 5905 Cobbs Creek Parkway | COA Pending | Philadelphia | PA | 19149
204561 | 5732 Chestnut Street |  | Philadelphia | PA | 19139 | ShippingAddress | 5905 Cobbs Creek Parkway |  | Philadelphia | PA | 19149 | [NAME] | COA Pending | Philadelphia | PA | 19139 | 5905 Cobbs Creek Parkway | COA Pending | Philadelphia | PA | 19149