I would like to use PQ to split a column of names obtained from a csv file (over which I have no control) which contains inconsistent data.
I have tried transposing and filling up and down, but cannot get a clean result. Ideally I would end up with 3 columns:
Honorific, First name, Surname
Mr Alan van de Velde
Mr Bob Vandevelde
Mrs Christine Vande Velde
David van de Velde
Ms Ellen Vanden velde
Fran Van de Vel De
Thank you
That will be a challenge. You could start with listing out all possible honorifics. Then you can at least identify the rows that have one and extract them. Then, will some people have double first names separated by a space?
If not, the attached file could help you on your way.
Thank you very much Riny
Separating out the honorifics will definitely help.
As to first names, you are also correct - we have Annabelle, Anna Belle and Anna-Belle as examples.
So using your examples using custom columns for the surnames, I will try to sort these out in the same way.
Many thanks for your time.
