I am in the process of trying to learn VBA. I am trying to write a macro
that will go through a list of data in excel and:

1. Sort Data
2. Find duplicates
3.If duplicates are found, move certain information to open column of the
master row
4. Delete Duplicate row

Problem

Item Mfg ID Mfg Itm ID Mfg ID-1 Mfg Itm ID-1 DFLT-1 Mfg ID-2
0804706 BETCOCHEM AF79
0804706 JOHNSONSON 4605
0810295 CARLISLE 3663300
0810295 CARLISLE (O)4155900

Hopefull End result

Item Mfg ID Mfg Itm ID Mfg ID-1 Mfg Itm ID-1
0804706 BETCOCHEM AF79 JOHNSONSON 4605
0810295 CARLISLE 3663300 CARLISLE (O)4155900

There will be multiple items that need to be moved to multiple columns.
Bottom line is that I am trying to create unique item numbers that could have
multiple part numbers.

Any help would be much appreciated.

thanks,

bob