Need formula

[Basavaraj K H]

Dear Team

Kindly refer attached file.

I have Site Id & Town Name in Column A & B in that I have delete Site Id Expcept 1st One, same as I mentioned in Column D.

Thanks in advance

Regards
Basavaraj K H

 

[Mike H..]

Hi,

Is this what you want.

 

[Basavaraj K H]

Thank You Mike

is it any formula.

 

[Mike H..]

Thank You Mike

is it any formula.

Some formula in Columns D and E. Drag them down.