Split Column of varying number of items by Delimiter

[StuartSmith]

I have a column I need to split by colon, but each cell in the column has a varying number of items.  In the Advanced section of "Split Column by Delimiter", there is the option to select the number of columns to split into, but if the number is to low, it doesnt split the column enough and if the number is too high, it splits into too many empty columns.  How can I split the column dynmically, depending on the number of items in a call.  Hope that makes sense.

Item

1, 2, 3

4

5, 6, 7, 8

9, 10

So it would split like this...

Item_1	Item_2	Item_3	Item_4
1	2	3
4
5	6	7	8
9	10

Thanks in advance.

[amitchandak]

@StuartSmith , My advice would be split into rows and then use matrix visual to display it