Hi.
I have a text document with every line in the A column. I want to move every second cell into the B column one cell above, and then delete the empty row. Exactly how do I do this? I am not familiar with using LibreOffice Calc, so please explain it to me with detailed instructions. Thank you.
Before
After
Hello,
another solution:
B1: =OFFSET($A$1,(COLUMN()-1)+(ROW()-1)*2-1,0)
C1 (or just copy)B1:C1
5 (now cells B1 to C5 should show what you want to achieve; attached sample file is at this stage)B:C
Data -> Calculate -> Formula to Value
A
See the following sample file: ArrangeEveryNth.ods
Hope that helps.
If the answer is correct or helped you to solve your problem, please click the check mark (
) next to the answer.
This is very good. Thanks for the help. I have one additional question. What would the formula be if you had say 5 rows of data at a time that you wanted to move into adjacent columns? The same thing, but instead of two.
should have pointed out where the N in my formula is:
N=2: =OFFSET($A$1,(COLUMN()-1)+(ROW()-1)*2-1,0)
N=3: =OFFSET($A$1,(COLUMN()-1)+(ROW()-1)*3-1,0)
N=4: =OFFSET($A$1,(COLUMN()-1)+(ROW()-1)*4-1,0)
N=5: =OFFSET($A$1,(COLUMN()-1)+(ROW()-1)*5-1,0)Very helpful. Thanks again.
Thank you so much!
Hi i have a similar but simplest thing to do i have a large work sheet which i want to move all the odd’s row two rows bellow, the 1 to the 3, the 3 to the 5 the 5 to the 7 etc… you can help me on that? I also wanted you to explain me parameters of the formula you use to i understand how it works if that is not hard for you…
Thank you!
Select the first two Rows… and in the Context_Menu of the Rows choose Insert Rows above …
Done!!
Karolus, thanks for the quick reply but i am afraid i was not clear, i don’t want to go all the rows two rows down, i want go two rows down only the odd rows. See the attached pic my worksheet is about 2500 rows like the pic, i want all the odd rows with the text to be under the even rows with the numbers.
oh I see…
in a new sheet enter:
=Sheet1.A2
=Sheet1.A1
into A1 and A2, select both and pull down.
please next time start a new topic instead reanimating a five year old one
Insert a further row in the beginning of the sheet. Write in A1 Content and in B1 Number.
Number column B this way: 1-2-1-2-1-2 or A-B-A-B… downwards. Do this: Insert in B2 A and in B3 B. Select cells B2 and B3 and cut the content out (CTRL+X). Then select B2 to B10 (or more) and insert clipboard. It will have the form of A-B-A-B-A… or 1-2-1-2-1-2 …
Select A1 and B1 and (Data menu) insert AutoFilter.
B1 contains filters (1 and 2 or A and B). Select 1 (or A) in filter.
Copy values of column A.
Create a new sheet and insert clipboard in A1 (or B1).
Go back to first sheet and select 2 (or B) in filter. Copy and paste into sheet 2.
Probably there’s a more elegant solution?