Hello all,

I have a database where I need to find duplicate rows based on one cell and concatenate the two cells from both into one record. For example i'll have:


Code:
ID             NameOne               IDNumber

1              John                        2983

2              Jones                      2983

3              James                     2984
...