Copy only specific cells from Column A, and paste them to Column B, but with no blanks

Hi,

I wish to copy certain cells from a column and paste them to another column with the new column not having any blanks between the

Using the example below.. I wish to copy the "blue" results in Column A, and paste them in Column B but just leaving with "blue" results AND no blanks/spaces between the rows!

Column A

Red
Blue
Red
Red
Blue
Blue

Column B
Blue
Blue
Blue

(column B is just showing the "blue" results with no spaces/blanks between the rows)

I hope this makes sense!


Any help would be great,


Kapil

Is there a way of doing this without filtering? I should have mentioned that I didn't want to use the filter tool!

Thanks

I just want to show all the info I need in one list (perhaps using a formula or VBA?) and without the use of filters.. Is this feasible?

ah, this is great.. however, I would like to go one step further..


Column A

John
Martin
Dave
Michael
Alex
Luke

Column B


Red
Blue
Red
Red
Blue
Blue


Column C

-
-
-

I would like to now copy and paste into Column C those names in Column A who have Blue "tagged" to them..


Please could you help me with this!