In my CSV, I have two columns which are really just one column, so I want to concatenate the content of these two columns - for each row - into the first one(after this I want to remove the extra column)? I use Mac, so I use LibreOffice and OpenOffice.
I like to complicate things so here what I would do:
- select both columns, right click,
Format Cells, select
- 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 Specialand select
Shift Cells(remove all other selections). If warning appears just click
Yesfor 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".