Hi All, I have a table that looks like this
ID | Name |
1 Bob Green
2 B Green
3 S Red
4 Sam Red
is it at all possible to somehow merge those 2 names into one field, perhaps Bob Green with a new ID of 5?
I don't even know where to start for something like this.
Thanks for all your help.