I have split the records with no dates without any problems. I Have filtered out the data that has dates in and the table is tblSandBoxFrom
MemberID Boats
1659 Courageous,1986,1988
1659 Conqueror,1977,1979
1659 Walrus,1977,1977
1659 Valiant,1983,1986
1660 Artemis,55,57
1660 Token,57
The ouput...