Remove Blanks from Adjacent cells

[jakewatson]

Hi Guys,

I'm trying to remove the blanks from an adjacent column as per the table below. Any ideas from you wonderful people?

Data 1	Data 2		Result
1	Cat		Cat
	Dog		Chicken
1	Chicken		Sheep
	Cat		Apple
1	Sheep
1	Apple
	Banana

<tbody>
</tbody>

Thanks!!!

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	Data 1	Data 2		Result
2	1	Cat		Cat
3		Dog		Chicken
4	1	Chicken		Sheep
5		Cat		Apple
6	1	Sheep
7	1	Apple
8		Banana
List

Cell Formulas
Range	Formula
D2	=INDEX($B$2:$B$8,AGGREGATE(15,6,(ROW($B$2:$B$8)-ROW($B$2)+1)/($A$2:$A$8=1),ROWS($A$1:$A1)))

 

[jakewatson]

Awesome!!, thank you!

 

[Fluff]

You're welcome & thanks for the feedback