|I think you've made it even more confusing, at least to me.|
In your OP you used the term second range but now your asking for the third rotation. Does rotation mean range? If so, why did you change from asking for the second to asking for the third?
In addition, the first example you posted looked like this:
but your second looks like this:
All ranges/rotations/whatever start and end with a 0, but your original dataset did not show that. In addition, what do the "..." mean?
Finally (at least for now) I can't tell from either of your examples or from your text whether these numbers and commas are all in one cell or if each individual number is in it's own cell and the commas don't exist or what.
Keep in mind that we can't see your spreadsheet from where we're sitting, so you need to be very specific (and consistent) .
If you need to post example data in columns and rows, click on the words How To in my signature line for instructions on how to do that.
Posting Tip: Before posting Data or VBA Code, read this How-To.