Thank you all for the quick replies!!
This ended up being the solution that worked the best for the data I had.
I had to split the string up and unique it in order to get the accurate penetration (multiple of the same items in the same basket) but got there in the end!
Definitely learned a bit more from this so thanks again!