paste numbers into 4 columns [closed]
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.
What was wrong with the formula @Jim K posted? It works flawlessly for the pupose. You won't find a ready-made tool for the very specific proceeding.
I didn't see it yet. Just now I hit the refresh button in my URL field and got these messages.
It does work flawlessly! It is the answer to my needs. I couldn't have ever figured out how to write that equation. Awesome!
I didn't see until 10 minutes ago. It does work flawlessly. Thanks @Jim K. I do not see where I can thank him except in these Comment boxes.
You're welcome!
The way to thank someone is to mark the answer as correct, which you have done, and consider upvoting the answer (maybe you did this too; it's anonymous so I'm not sure). Optionally add a comment, which you have also done. It would have been more proper to comment on the answer, rather than the question, but that's a minor point.
I looked there but thought that it would be commenting on the comment about commas and semi-colons.