Separating data in a single column

I have data exported from a ticketing/retails system which lumps all the items purchased by each customer in one column, with values separated by commas.  There's potentially 100 different items they...