Auto Populate value from cells to another column

[geriboi]

Dear All,
Hope you could help me find an excel formula for below condition. Thank you

<tbody>
[TD="class: xl65, align: left"]Celll reference[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64, align: left"]result[/TD]

[TD="class: xl65, align: left"]Item[/TD]
[TD="class: xl65, align: left"]Qty[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]

[TD="class: xl65, align: left"]Apple[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Apple[/TD]

[TD="class: xl65, align: left"]Banana[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Apple[/TD]

[TD="class: xl65, align: left"]Mango[/TD]
[TD="class: xl65, align: right"]0[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Apple[/TD]

[TD="class: xl65, align: left"]Apple[/TD]
[TD="class: xl65, align: right"]2[/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Banana[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Banana[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Apple[/TD]

[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65"][/TD]
[TD="class: xl65, align: left"]Apple[/TD]

</tbody>

 

[Peter_SSs]

Try using a helper column like this. The helper column could be hidden.
Both formulas copied down.

Excel Workbook
	A	B	C	D	E
1	Item	Qty
2	Apple	3	1		Apple
3	Banana	2	4		Apple
4	Mango	0			Apple
5	Apple	2	6		Banana
6					Banana
7					Apple
8					Apple
9
List

 

[geriboi]

Dear Pete,
Thank you for your time to analyze and reply. This would help me a lot.

 

[Peter_SSs]

Dear Pete,
Thank you for your time to analyze and reply. This would help me a lot.

You are very welcome. Thanks for letting us know.