Remove blank cells from column and output list in another column

[mlektra]

Hi guys, I want to remove blank cells from a column and output list in another column. I have joined a picture to show you.

List is starting at F:3 and goes to F:80. There is a lot of blank space.

I want to output in column G. Starting at G3.

Thanks for the help.

 

[Redwolfx]

First create a list from your original Values. Highlight F3:F80 then Above Column A in the text box that should read F3 Type "List"

Then in G3

=IFERROR(INDEX(List, SMALL(IF(FREQUENCY(IF(List<>"", MATCH(ROW(List), ROW(List)), ""), MATCH(ROW(List), ROW(List)))>0, MATCH(ROW(List), ROW(List)), ""), ROW(A1)), COLUMN(A1)), "")

Confirm with Ctrl+Shift+Enter

Then Drag that down to G80

 

[mlektra]

not sure about this. I can't really move or rename stuff. Best thing I can do is to remove titles and grey bar and have my source list in F1.

I can't change what is in F column, this is an output of previous columns (A, B, C, D, E) And theres already stuff in these columns. My list appears like that in F column and I can't really change it. I can start the data wherever I want (F1..F2..F3..) but I must start with that list there.

 

[bruderbell]

Here's my stab:
=IFERROR(INDEX($F$3:$F$80,SMALL(IF($F$3:$F$80<>"",ROW($F$3:$F$80)-ROW($F$3)+1,""),ROWS($F$3:F3))),"")

Enter that in G3 with Ctrl Alt Enter, then drag it down

Also, best of luck finding your love.

 

[Redwolfx]

You wouldn't be changing anything just naming a range as a list.

 

[mlektra]

Wow amazing Burderbell. Excellent, it is working!