Filter with non blanks and copy those values.


On Jul 18, 10:32*pm, Narnimar
wrote:
I got a list in B:B in which there are values in but some are blank. I need a
if formaula can *summerize it in A column with only those which are
nonblanks.
A * * * * * B
Car * * * *2
Bus * * * *1
Train * * *blank
Flight * * *blank
Cycle * * *20
Horse * * Blank

the sumery should apear just like -
A * * * * * B
Car * * * *2
Bus * * * *1
Cycle * * *20

Any Help is highly appreciated.