First time here? Check out the FAQ!
Ok, while I support @ebot's comment, seeing there's already a solution posted, I'll re-post this formula to be put into D1 and drag-copied to D64:
=TEXTJOIN(" ";0;OFFSET($A$1;MOD(QUOTIENT(ROW()-1;4^0);4);0);OFFSET($A$1;MOD(QUOTIENT(ROW()-1;4^1);4);1);OFFSET($A$1;MOD(QUOTIENT(ROW()-1;4^2);4);2))
ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.
If the answer met your need, please click on the ball to the left of the answer, to finish the question.
Asked: 2019-08-27 13:05:51 +0100
Seen: 111 times
Last updated: Aug 27 '19
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
It does not matter if you pay more attention at school. ;-) You can do it, if you strain your brain. I wish you success.