Put in order without blanks

[bluefeather8989]

In cells C18:C30 is a list of numbers and letters that are values from a formulas. I nee a way if possible to Order these without the blank.example in E18:E30.

 

[StephenCrump]

Like this perhaps:

	C	D	E	F
17	Formula	Filter blanks
18	1	1		1
19	2	2		2
20	3	3		3
21	4	4		4
22	5	5		5
23	6	6		6
24	7	7		7
25		R
26		H
27		E
28	R			R
29	H			H
30	E			E
Sheet1

Cell Formulas
Range	Formula
C18:C30	C18	=IF(F18:F30="","",F18:F30)
D18:D27	D18	=FILTER(C18:C30,C18:C30<>"")
Dynamic array formulas.

Or in one go, if the formula is an array formula:

	C	D	E	F
16	Filtered
17	Formula
18	1			1
19	2			2
20	3			3
21	4			4
22	5			5
23	6			6
24	7			7
25	R
26	H
27	E
28				R
29				H
30				E
Sheet1

Cell Formulas
Range	Formula
C18:C27	C18	=LET(f,IF(F18:F30="","",F18:F30),FILTER(f,LEN(f)))
Dynamic array formulas.

 

[Cubist]

Try

=TOCOL(C18:C30,1)

 

[bluefeather8989]

Three different way to accomplish this and the all work great. Thanks for the help.

StephenCrump​

Cubist​