Can anybody help me to update the notes field. If customer have multiple email addresses but one of the row does not have email address. Update the Notes field as shown below. If customer have one row and have no email address. Update the Notes field as stated below.
Input File
| Customer ID | Customer First Name | Customer Last Name | Address1 | City | State | Zip | Email |
| A101 | Robin | Robson | 223 Orchard Drive | Madison | PA | 45602 | RobinPA@gmail.com |
| A101 | Robin | Robson | 223 Orchard Drive | Madison | PA | 45602 | RobinPA@Yahoo.com |
| A101 | Robin | Robson | 223 Orchard Drive | Madison | PA | 45602 | |
| A503 | Carrie | Sobers | 655 Tulip Ct | Hobert | GA | 56543 | |
Output File
| Customer ID | Customer First Name | Customer Last Name | Address1 | City | State | Zip | Email | Notes |
| A101 | Robin | Robson | 223 Orchard Drive | Madison | PA | 45602 | RobinPA@gmail.com | |
| A101 | Robin | Robson | 223 Orchard Drive | Madison | PA | 45602 | RobinPA@Yahoo.com | |
| A101 | Robin | Robson | 223 Orchard Drive | Madison | PA | 45602 | | Email Exist for this customer. Email append is not require. Delete this row. |
| A503 | Carrie | Sobers | 655 Tulip Ct | Hobert | GA | 56543 | | Email does not Exist for this customer. Email append is require. Keep this row. |
