I hope the title makes sense. I want to split data from a single cell into multiple cells. Each cell on a row has different items listed. Some have 14 items, other 2 or 3, in the same cell. The only item seperating each listed data is a semicolumn. I did "text-to-columns" but I can only separate the first item listed. Here's an example of what it looks like.
I've been searching everywhere for the last hour and just can't find anything. I appreciate any help you can provide.