How do I sort by ranges?

[Clevernewt]

I have s spreadsheet where the data are in ranges,
with some cells empty,
and I need to sort the data by a velue in one of the columns,
but to keep the ranges as they are.
What should I do?

 

[Dave Peterson]

Maybe you can put a key value (in another column) in each set of rows that
should be sorted together. Then you could sort by that key value.

You may need a second column so that the rows should be sorted together stay in
the correct order.

KeyA 1
KeyA 2
KeyA 3
KeyB 1
KeyB 2
....

 

[Clevernewt]

Thank you,
I'll try.

Maybe you can put a key value (in another column) in each set of rows that
should be sorted together. Then you could sort by that key value.

You may need a second column so that the rows should be sorted together stay in
the correct order.

KeyA 1
KeyA 2
KeyA 3
KeyB 1
KeyB 2
....