Forum Discussion
Solved
First and Last Name Order
I have a column containing first and last names but the order is not consistant, sometimes the order is Last Name First Name and sometimes the order is Fist Name Last Name (eg. Hoyer Prue and Prue Ho...
=Text.Combine(List.Sort(Text.Split([Name]," "))," ")
this can help to find the duplicated names, but it can no recognise which is the first unless you have a supporting list of first name or last name.
How would that help if you're not finding a way to identify which is first and which is second?
The split gives
| Hoyer Prue | Hoyer | Prue |
| Prue Hoyer | Prue | Hoyer |
Then combining
| Hoyer Prue | Hoyer Prue |
| Prue Hoyer | Prue Hoyer |
=Text.Combine(List.Sort(Text.Split([Name]," "))," ")
this can help to find the duplicated names, but it can no recognise which is the first unless you have a supporting list of first name or last name.