Moving a column of text data into 3 columns of data?

Hi Bob_Myers​ ,

Can you paste a screenshot of 

1. What you have exactly (sample)
2. What you'd like it to be

My brain says that MAYBE in your example you didn't REALLY mean:

Cell in Columns.

1,2,3

3,4,5

5,6,7

8,9,10

but rather:

Cell in Columns.

1,2,3

4,5,6

7,8,9

...and so on.

The sequences you expressed {1,2,3;3,4,5;5,6,7} seems doable - but if this is really what you want I would have expected the next set of three in the sequence to be {7,8,9}, NOT [8,9,10}

So give us a picture to remove confusion. :)