Hi there, i was hoping someone could help me with this query. i have a large set of address data which needs to be cleansed and analysed to find duplication within rows. i have included a sample set of data which hopefully will portray my issues. Hopefully, someone can help.
|Name||Address 1||Address 2||Address 3||Address 4||Address 5|
|Neil Magee||Mountain View||Kells||Kells||Co Meath|
|Neil Magee||The View||Navan||Co Meath|
|Mary Murphy||Springbank Way||Buttevant||Co Cork|
|Brian Murphy||The Maze||Nenagh||Nenagh||Co Tipperary|
|David Duval||6 O'Connell St||Dublin||Dublin||Co Dublin|