How to sort a column with blanks to another without!

[ELGendi]

Hello everyone,

I have a column with blanks , I want to sort them in another column sequentially ,, any idea ?



Thanks in advance

[Glenn Kennedy]

Is this an Excel question, or a Googlesheets question, or what???

This will work with Excel 2010+. I have no idea if there is an equivalent in GS:

=IFERROR(INDEX(D:D,AGGREGATE(15,6,ROW($D$2:$D$19)/($D$2:$D$19<>""),ROWS(G$2:G2))),"")

copied down. See sheet.

[ELGendi]

Glenn ,,

Thanks a lot , yes it works with office as you explained , I am on google sheet unfortunately ,
I tried to upload it maybe google sheet can do something , but didt work out , do you know how to do it with GoogleSheets ?

[Fluff13]

Maybe
=SORT(FILTER(C3:C20,C3:C20<>""))

[Flyboy65]

For Google Sheets, if column A has the numbers with spaces, put the following in the column you want the sorted numbers:

=SORT(A1:A,1,TRUE)

[ELGendi]

Maybe
=SORT(FILTER(C3:C20,C3:C20<>""))

Yes, that is exactly what I wanted , it works perfectly , Thanks a lot

[Fluff13]

Glad to help & thanks for the feedback

[ELGendi]

For Google Sheets, if column A has the numbers with spaces, put the following in the column you want the sorted numbers:

=SORT(A1:A,1,TRUE)

Pardon my friend , the values are from z to a , can i reverse the order ?

[Flyboy65]

ElGendi, Change the TRUE to FALSE

[ELGendi]

Hi,
Excuse me , I did mean the (Fluff13 ) formula , the one I want to reverse , but while trying yours as well worked out , and the reverse was resolved as well , but it's very down to the list no in the upside where I did type the formula

[ELGendi]

just for reference for whoever might need it, I used
=LARGE(AB1588:AB1637,1)
=LARGE(AB1588:AB1637,2)
=LARGE(AB1588:AB1637,3)

=small(AA1588:AA1637,1)
=small(AA1588:AA1637,2)
=small(AA1588:AA1637,3)

of course my solution is good with small entries , but the above ones from our friends would be efficient in case you are dealing with large scale.

Thanks all for your time.

Regards!