How to wrap a series of numbers into a table of selected cells?

English
#1

So that they stop at the end of the highlighted row, the right side of the table where it ends and have it continue off at the left of the next column below it.

Here is what it is doing, I’m very close to succeeding, but the numbers continue on endlessly in the first row. See screenshot:

image
image1280×420 61.3 KB

https://postimg.cc/YvQr11ZV

I need them to stop at the end of the blue selection and continue again in the next blue column below.

Here is the ODT file:
https://upload.disroot.org/r/sBS5BD1B#SZJ052ks8KiUiWBI5tQ5MBP23IKkdjadRSQDJBr3Avo=

excel.ods (10.3 KB)

And here is an example of a series of numbers:
10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32,10, 31, 34, 6, 14, 3, 16, 23, 6, 33, 15, 32

-Thanks!

[Edit] Uploaded image and sample file so broken links won’t be a problem in future. [robleyd]

#2

15 columns wide. Assuming the line of numbers starts in A1, you could enter in A2 =OFFSET(A$1;0;(ROW()-1)*15) and drag across to column O and then drag the whole lot down until you get zeroes appearing showing that you have reached the end of the numbers.
WrapLineOfNumbers.ods (13.7 KB)

Then copy and paste as unformatted text

2 Likes
#3

Thank you very much, that did the trick! I’d cashapp you if I had the money, but I got about $100 to my name though.

#4

Cross posted to Reddit.

If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.

1 Like
#5

I’ve received three or four replies on different forums, and every single answer was uniquely different & good.

#6

Fine.
But it doesn’t touch on what @robleyd meant.
The multitude of the good solutions you got suggested is not available to visitors not knowing your additional posts. To also let others know is about what @robleyd worded as “courtesy”.

2 Likes
#7

Here is only other place I’ve posted:

1 Like

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.