Ive got a long list of about 2000 names in column A in an excel sheet, there are only about 40 different names and they are all repeated. I need to sort them by name into columns. Some of the names like bob / bobby and ben / benjamin are counted as the same so would get sorted into the same column. I need to get all the sams and put them into column D, all the bob / bobbys into column E, all the james into F, ect ect
What would be the best way to approach this ?
thanks in advance