How to merge 2 columns into one in LibreOffice or OpenOffice?
I like to complicate things so here what I would do:
- select both columns, right click,
Format Cells
, selectText
format - right click first column and select
Insert Columns Left
- insert formula
=CONCATENATE(B2,C2)
(or whatever cells you need to concatenate) and pull down so the cells will fill with the correspondent concatenation - select the created first column and copy it
- right click first column, select
Paste Special
and selectText
underSelection
,None
underOperations
andDon't shift
underShift Cells
(remove all other selections). If warning appears just clickYes
for overwriting the current cells - Now we have a column with the concatenated texts, so you can delete columns B and C (or whichever you have concatenated) and this will leave the concatenated text in first column (no formula there)
The "standard" solution seems too much of a trouble for such a simple thing, so here is what I'll use :
- Select and copy your columns.
- Paste them into a text editor.
- Use your editor "search and replace" function to convert tabulations into spaces.
- Copy the result.
- Paste it into your Gnumeric/LibreOffice/OpenOffice sheet, checking "fixed width".