Replace column with other column then delete

Hello,
Respected Seniors and friends,
Feeling proud here among You ALL
Happy Holi
Holi is an auspicious festival of India.
I’m not good in English so please bear with me,
I attached picture of my query here named Chandus problem.png . Please help.

(1) I have an excel file
(2) The File has 9 columns viz,
COL A, COL B, COL C, COL D, COL E, COL F, COL G, COL H, COL I
(3) COL A includes Name entries
(4) COL H also includes Name entries.
(5) All Names of COL H are in COL A but,
All Names of COL A are not in COL H
(6) COLUMNS B, C, D, E, F, G and I have numerical data but,
COL I has data corresponding to COL H’s Names and COL H has Names
among majority Names are present in COL A.

What I want,

I want to Merge (Replace) all entries of COL H into COL A and then delete COL H.
So, COL I becomes COL H.
Want, To set entries of COL I (now COL H) against corresponding Replaced entries of COL A.
Want to allot value ZERO (0) in COL H, against entries of COL A which are not replaced by entries of COL H

Thanks in advance,
Yours,
Chandu