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?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Data 1[/TD]
[TD]Data 2[/TD]
[TD][/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Cat
[/TD]
[TD][/TD]
[TD]Cat[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Dog
[/TD]
[TD][/TD]
[TD]Chicken[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Chicken[/TD]
[TD][/TD]
[TD]Sheep[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Cat[/TD]
[TD][/TD]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Sheep[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Apple[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Banana[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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