You are not logged in.
- Topics: Active | Unanswered
#1 2021-07-16 02:25:43
- makh
- Member
- Registered: 2011-10-10
- Posts: 305
Libre office: convert 2 columns to one column
Hi
I am having data in two columns:
A1 B1
1 a
2 b
3 cI need to convert into single column in this way:
A1
1
a
2
b
3
cIs there any possibility: as I can find only the merge / concatenate options! Transpose is not useful for me!
Thankyou
OS: Arch &/ Debian
System: LENOVO ThinkPad E14
Desktop: Xfce
Offline
#2 2021-07-17 15:30:32
- mpan
- Member
- Registered: 2012-08-01
- Posts: 1,638
- Website
Re: Libre office: convert 2 columns to one column
For Calc:
If it’s only for values, not formulas or formats, you can achive that with the following formula, which must start at the same row as the original data (but at any column).
=INDIRECT(IF(ISODD(ROW()),ADDRESS(FLOOR(0.5+ROW()/2),1),ADDRESS(FLOOR(0.5+ROW()/2),2)))You can then select the results and copy-paste values only, into a location of your choice.
For Writer:
Copy table to Calc, follow the instructions above, copy data back.
Last edited by mpan (2021-07-17 15:31:20)
Offline