Row sorting question

Giganews Newsgroups
Subject: Row sorting question
Posted by:  jezzica85
Date: Thu, 4 May 2006

Hi all,
I have a spreadsheet of almost 7000 rows and 32 columns., set up something
like this:

a  0 0 0 0 2 3 0 4 3
b  1 2 3 0 0 0 3 1 6
c  0 0 1 3 3 5 6 7 2
d  1 2 3 4 0 0 0 0 0
e  0 0 0 3 2 1 4 3 2
f    0 0 0 3 0 1 4 4 5

Does anyone know if there's a way to sort the columns by the number of zeros
that start the row, with the least at the top, so it would look like this:

b  1 2 3 0 0 0 3 1 6
d  1 2 3 4 0 0 0 0 0
c  0 0 1 3 3 5 0 7 2
e  0 0 0 3 0 1 4 3 2
f    0 0 0 3 0 1 4 4 5
a  0 0 0 0 2 3 0 4 3

Thanks a lot!
Jezzica85

Replies