Adding a Column based upon on Duplicate Name ?

I'm an Excel amateur and was hoping for some assistance or suggestions. I need to parse through a large data sheet and add/merge a column if I encounter a duplicate. Here is an example of the current data set:

Name Port
AMGT1 50:01:43:80:24:22:79:c4
AMGT1 50:01:43:80:24:22:79:c6
zaa1 10:00:00:00:c9:56:de:bb
zaa1 10:00:00:00:c9:6d:d4:6d
zad1 10:00:00:00:c9:5c:1e:e0
zad1 10:00:00:00:c9:89:4e:ee

Since i have two rows with AMGT1, I need to merge them together so that a new column is created with the new entry so it looks like this:

AMGT1 50:01:43:80:24:22:79:c4 50:01:43:80:24:22:79:c6

I'm sure this is possible, I just do not have a clue how to do it. Any assistance would be appreciated. I realize my Title doesn't exactly capture the nature of my issue. Thank you.

Hi gud mrng,

Please check the attachment. run the macro and see the final solution in the sheet named "result".Let me know if its ok.

Babu.S

Thank you for the reply. I'm not sure why, but the worksheet "result" is blank.

Did you run the macro? it works well for me.

It runs, I see the result set. I just need to add 50:01:43:80:24:22:79:c6 into column C as opposed to joining it to column B

AMGT1 50:01:43:80:24:22:79:c4 50:01:43:80:24:22:79:c6

Thanks again.

i have made some adjustments such that 50:01:43:80:24:22:79:c4 will be in column B & 50:01:43:80:24:22:79:c6 will be in column C for AMGT1. let me know if its ok.

Babu.S

Babu,

Thank you very much! I really appreciate you taking the time to assist me with this. It works perfect.

Sorry Babu,

When I run this against the fill data set, I get some errors ... The full sheet consists of about 800 lines. Any ideas? I looked at the macro, but I do not understand the syntax.

Name Port
BPTBNXIAMGT1 50:01:43:80:24:22:79:c4 50:01:43:80:24:22:79:c6
cazaa1 10:00:00:00:c9:56:de:bb 10:00:00:00:c9:6d:d4:6d
cazad1 10:00:00:00:c9:5c:1e:e0 10:00:00:00:c9:89:4e:ee
cazap1 #VALUE!
cazap9 #VALUE!
dove #VALUE!
drah #VALUE!
dr-bi
I0510
I4302
I4302
maynard

Could you pls attach the template file removing sensitive datas?