Hi, I know what I would like to automate but difficult to put into words.
I have a list of names and addresses, there are three options, the first option is that there are family members Mum Dad and Siblings, the second option is that there is a single person and the third option is that there seem to be flatmates or a couple that have retained their own surnames. refer FAMILIES RAW
What I would like to do is to create a Family Row for the first option, moving the first “Famly name” in the Surname Colum from the Surname Colum to the First Name Colum then in the Surname column Change the " Family name " to Family then delete the rows that contain the duplicate members of the family.
I do not wish to alter the rows that do not contain what would seem to be family members based upon duplicate Surnames.
For the result, I desire refer to FAMILIES edited
I see that there could be some problems with Van and van etc but could be easily overcome with “Text to Column”.
I hope some nice person can help even if you get me started I would be grateful.