[libreoffice-users] Calc - sort in to columns

Hi

Calc

I've been scratching my head, racking my brain and grinding my teeth - non
of which worked

How do I sort out from a mixed list of membership types the email addressers
into separate columns without gaps or 'false' or '0' appearing
I've attached a simple mock up to make sense of my garbled explanation -
hope it makes sense anyway

Thanks for any solutions  test2.ods
<http://nabble.documentfoundation.org/file/n4098035/test2.ods>  



-----
IGraham

W764  LibreOffice 4.1.42
--
View this message in context: 
http://nabble.documentfoundation.org/Calc-sort-in-to-columns-tp4098035.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted