Sort data in Excel with blank rows?

[JohnnyBeGood]

Hi all,

I've tried searching here and spent few hours trying myself but I cannot find solution how to sort when there's blank rows. It always removes spaces in between.
I need to sort column B along with text that is on the same row.
Any suggestions?

Not sorted:

Sorted:

TIA!

 

[footoo]

Make sure B10 is the active cell before entering the formula.

OR :
Instead of • Type =B9 and press Ctrl+Enter

Type =
Press the up arrow
Press Ctrl+Enter

 

[JohnnyBeGood]

Below is what it shows and happens after I manually select blank cells B9:B20 and hit CTRL+Enter

 

[footoo]

What formula is in the previously blank cells after pressing Ctrl+Enter ?

 

[JohnnyBeGood]

No formula just plain numbers.

 

[footoo]

I mean cells B10, B12, B14, etc where you are supposed to enter a formula.
You are not following the steps.
Look again at post #11.

 

[JohnnyBeGood]

Sorry!
B12 =B1
B14 =B3
B16 =B5
B18 =B7
B20 =B9

 

[JohnnyBeGood]

Example

Example.xlsx
	A	B	C	D	E	F	G	H	I	J	K
4
5			Subject
6
7
8
9		13		TEXT EXAMPLE
10		#REF!
11		12		TEXT EXAMPLE
12		0
13		10		TEXT EXAMPLE
14		0
15		1		TEXT EXAMPLE
16		0
17		2		TEXT EXAMPLE
18		0
19		3		TEXT EXAMPLE
20		13
Sheet1

Cell Formulas
Range	Formula
B10	B10	=#REF!
B12,B20,B18,B16,B14	B12	=B1

 

[footoo]

You are not following post #11

 

[Dossfm0q]

Hi FooToo

It is Ok by Typing the last nonblank "B17" cell instead of First nonblank "B9"

 

[footoo]

O

Hi FooToo

It is Ok by Typing the last nonblank "B17" cell instead of First nonblank "B9"

Or just follow post #11

It is Ok by Typing the last nonblank "B17" cell instead of First nonblank "B9"

The last blank cell is B20, so the formula in this cell would be =B19