Hi I hope someone can help.
I have a table with records in like the follwowing examples.
Record 1
ID - 1
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Tilly
Record 2
ID - 2
AccountID - 123
Name - Mr Smith
Address - 38 The Close
PetName - Chloe
Record 3
ID - 3
AccountID -...