0

I have this ODF Spreadsheet on LibreOffice open, at it has one column with a lot of data that I wish to retrieve, however, I also have, a lot of white cells. Something like this:

emailA
emailB
--empty cell--
--empty cell--
emailC
--empty cell--

And I wish to have:

emailA
emailB
emailC
--empty cell--
--empty cell--
--empty cell--

The main point being that of exporting this to a csv file or something so that I use this addresses.

Can I have your help please?

Thanks in advance.

3
  • 2
    I am not aware of LibreOffice, but in Microsoft Office one can sort the workbook alphabetically with items in a single column. And that gets all your empty cells to top/bottom of the workbook.
    – Mallik
    Feb 24, 2012 at 11:01
  • Thanks, that did the trick. No easy still. We must go to "Data" then "Sort" then the tab "options" and finally, uncheck "Range Contains Column Labels"; uff... :)
    – MEM
    Feb 24, 2012 at 11:21
  • If you need to do it all the time, create a macro and attach to a keyboard shortcut. Mar 7, 2013 at 23:14

1 Answer 1

0

Just sort the column and the blank entries will go after the entries containing data.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .