Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 09 Nov 2017 19:05:51 +0100paste numbers into 4 columnshttps://ask.libreoffice.org/en/question/137524/paste-numbers-into-4-columns/I want to take a column of 120 or so numbers from a spreadsheet and enter them in another spreadsheet in 4 columns.
So, the first 4 numbers would be side by side in row 1 and the second 4 numbers would be in row 2.
I have a workaround that is doable but labor intensive. I can highlight the first and 5th and 9th etc. numbers until I get to 117, and then Copy or Cut and then Paste into the new spreadsheet.
And repeat 3 more times.
I think there should be someone out there who has already figured this out.
If not, maybe I'll need to learn how to write a Macro.joeh6966Thu, 09 Nov 2017 19:05:51 +0100https://ask.libreoffice.org/en/question/137524/