Spreadsheet: 782683d1654182718-combining-multiple-records-with-unique-value-into-one-row-sample
Sheet: Examples

[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
Has _MailingAddress listed as a Contact Type
80173 | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | _MailingAddress | 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 | Father | 555 Anderson Street Extension |  | [NAME] | PA | 16740
80173 | 555 Anderson Street Extension |  | [NAME] | PA | 16740 | Mother | 555 Anderson Street Extension |  | [NAME] | PA | 16740
 |  |  | Comment:  Moved the Contact Address columns where the Contact Type = _MailingAddress to the [NAME] columns
 |  |  |  | Moved the Regular Address to the Shipping Address columns - because this student does not have a Shipping Address as the contact type
Has _MailingAddress & COA listed as a Contact Type
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | _MailingAddress | 111 Aspen Circle |  | East Stroudsburg | PA | 18302 | 221 [NAME] | Suite 208/281 | East Stroudsburg | PA | 18301 | 111 Aspen Circle | COA Pending | East Stroudsburg | PA | 18302
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | COA | 111 Aspen Circle |  | East Stroudsburg | PA | 18302
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | Father | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302
308066 | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302 | Mother | 2553 Lynnwood Drive |  | East Stroudsburg | PA | 18302
 |  |  | Comment:  Moved the Contact Address columns where the Contact Type = _MailingAddress to the [NAME] columns
 |  |  |  | Student has a COA as a Contact Type.  Moved that contact address to Shipping Address and added "COA Pending" to Shipping2 column
Does not have _MailingAddress listed as a Contact Type, but does have COA listed as a Contact Type
308438 | 112 Custer Avenue |  | Vandergrift | PA | 15690 | COA | 128 Elder [NAME] | Apt 2 | Leechburg | PA | 15656 | 128 Elder [NAME] | [NAME] | Leechburg | PA | 15656 | 128 Elder [NAME] | Apt 2 - COA Pending | Leechburg | PA | 15656
308438 | 112 Custer Avenue |  | Vandergrift | PA | 15690 | Mother | 112 Custer Avenue |  | Vandergrift | PA | 15690
 |  |  | Comment: Student has COA listed as Contact Type and does not have _MailingAddress listed as Contact Type.
 |  |  |  | Moved the COA Address to the Mailing & Shipping Address columns
 |  |  |  | Added "COA Pending" to the end of the data within the Contact Address2
Does Not has _MailingAddress or COA listed as a Contact Type
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
 |  |  | Comment: Moved Regular Address columns to MailingAddress and Shipping Address columns, as this student does not have a _MailingAddress Contact Type