Attached is a spreadsheet of members of an organisation. All the records in yellow need adjusting as there are some memberships records that have duplicated when there are partners or families that are members.
For example, line 11 is Valerio Adriano and Line 12 is Margaret Adriano. This just needs to be one record with the first name being Valario, the partner first name being Margaret and the partner last name being Adriano. Also there is a column for 'member no' and the letter needs to be removed off the end so it is 3721
This would mean that line 12 would be removed and the partner information put into the correct columns in line 11 and the member no changed so it does not have the letter on the end.
This needs to be done on all records that are highlighted yellow in the spreadsheet.
Also, please note that some of these may not have a duplicate record. For example line 29 is for Daniel & Fiona Belatti. This just needs the partner first name changed to Fiona and the Partner Last name set to Belotti