Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.