Day 32

Task:

You run marketing operations for a small online retailer. This week's newsletter signups came in through three different forms, so the emails your export gives you are in inconsistent case — the mail platform treats "Priya.Patel@GMAIL.com" and "priya.patel@gmail.com" as two different addresses, which would double-count some subscribers. Before loading the list, put a lowercase version of each email in column C for de-duplication, and each signup's username — the part before the @, in its original case — in column D for a personalized greeting.