I have a problem to which I can’t find answer anywhere. I have a long list of costs with employee names. The problem is that the names in the list are not consistently written. Sometimes the 1st name comes first, sometimes the 2nd. E.g. it can be John Doe or Doe John. I have nearly 40,000 lines with more than 1,500 employees. As a result, when I insert a pivot table I have two records for the same person, therefore my results are not correct.
Can someone advise me a solution?