Hi - I have an excel spreadsheet with about 5,000 rows that have email addresses. Some of these email addresses are duplicate. They are from email campaigns. It shows that email A, opened an email on date x and date y. So therefore some of the emails are duplicative.
I am trying to do a pivot that says - Email A shows up X times on the spreadsheet, and sum of the Opens and Clicks that are next to it.
See attached - I also made notes of the example I am trying to output.
** Please note - this data is not real - I did a find/replace with certain characters to protect individual data.
Bookmarks