Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
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 '12 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 '12 at 11:21
    
If you need to do it all the time, create a macro and attach to a keyboard shortcut. – Julian Knight Mar 7 '13 at 23:14

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

share|improve this answer

You must log in to answer this question.

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