Hi There,
I need some help please.
I have a data set containing 65536 lines with details such as company name, names & surnames, email addresses etc. a lot of the line items contain duplicate details of the name & surname and email address. In order to remove these duplicates I have created a pivot table making it 13000 lines. In this pivot table the name & surname field appears in column B and the email address in column C.
I have two questions relating to the pivot table:
I need an idiot proof step-by-step process on how to go about this please?
Thank you in advance!
Adrene
I need some help please.
I have a data set containing 65536 lines with details such as company name, names & surnames, email addresses etc. a lot of the line items contain duplicate details of the name & surname and email address. In order to remove these duplicates I have created a pivot table making it 13000 lines. In this pivot table the name & surname field appears in column B and the email address in column C.
I have two questions relating to the pivot table:
- How can I split the "Name & Surname" column to show name and surname separately in two different columns?
- Some of the email addresses contain "*40" instead of the "@" sign, how can I fix this in the data set without manually fixing each one. (E.G. Joe.Soap*40gmail.com)
I need an idiot proof step-by-step process on how to go about this please?
Thank you in advance!
Adrene