Hi,<o
></o>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.<o
></o>Can someone advise me a solution?<o
></o>Thank
you.<o
></o>
