Using comma separated values in a single cell

Thanks for the input newdoverman (&FDibbins). Your first post does work, but will not fulfill all the possible scenarios of my stock transactions. BUT, I think your post second postgot the wheels turning. Since I have 100's of stock transactions per year I need to have uniqueness to each transaction. I can reverse my current spreadsheet logic to assign transID's to only sells and then associate those transID's with the buys and divy's. Awesome, thanks for y'alls help with this problem.
Joe