I have a file with 3500+ rows of data that I'd like to sort. However, I have
two blanks rows between each row of valid data. I want to keep each row of
valid data separated by two blank rows as they are now, even after being
sorted.

Can this be done? If so, how do I go about setting it up?

Thanks.

Do you mean that you want to sort each block of valid data (i.e.
between each set of blank rows), or do you want to treat all data as
part of one big block and sort that? What is it that determines the
break between each block of data?

Pete

I have a row of data followed by two blank rows, another row of data followed
by two blank rows, and so on for 3500+ rows.

I want to sort lowest to highest, yet keep two blank rows between each row
of data.

I hope I'm describing this ok. :-)

Thanks.

"Pete" wrote:

Do you mean that you want to sort each block of valid data (i.e.
between each set of blank rows), or do you want to treat all data as
part of one big block and sort that? What is it that determines the
break between each block of data?

Pete

MAB,

Sort the data, then add the blank rows..

After the data is sorted, in an adjacent blank column, insert 3
consecutive sets of identical numbers from 1 to 3500 ( or whatever).
Then sort by the numbered column.
Sort the following and see what you get...

1 Adams
2 Jones
3 Washington
1
2
3
1
2
3
'-------------------

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"MAB" wrote in message ...
I have a row of data followed by two blank rows, another row of data followed
by two blank rows, and so on for 3500+ rows.

I want to sort lowest to highest, yet keep two blank rows between each row
of data.

I hope I'm describing this ok. :-)

Thanks.

"Pete" wrote:

Do you mean that you want to sort each block of valid data (i.e.
between each set of blank rows), or do you want to treat all data as
part of one big block and sort that? What is it that determines the
break between each block of data?

Pete

It worked perfectly.

Thanks!

"Jim Cone" wrote:

MAB,

Sort the data, then add the blank rows..

After the data is sorted, in an adjacent blank column, insert 3
consecutive sets of identical numbers from 1 to 3500 ( or whatever).
Then sort by the numbered column.
Sort the following and see what you get...

1 Adams
2 Jones
3 Washington
1
2
3
1
2
3
'-------------------

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"MAB" wrote in message ...
I have a row of data followed by two blank rows, another row of data followed
by two blank rows, and so on for 3500+ rows.

I want to sort lowest to highest, yet keep two blank rows between each row
of data.

I hope I'm describing this ok. :-)

Thanks.

"Pete" wrote:

Do you mean that you want to sort each block of valid data (i.e.
between each set of blank rows), or do you want to treat all data as
part of one big block and sort that? What is it that determines the
break between each block of data?

Pete