I have this xml document that is provided as a data feed (right off the bat I can not modify the source of the data feed) and i import it into excel with the xml import. there is no schema that comes with this xml so i get a table that ends up having a whole bunch of duplicates for an identifier, because of the unique values spread throughout the spreadsheet.

XML in XLS

Col1(IDnum)   Col2(name)   Col3(Type)   Col4(Category)   Col(etc)
=================================================================
0011           Item          01                           6B
0011           Item                        xxj9           7B
0011           Item                        xxj9
0011           Item          02
0011           Item          01            xxj9           6B
0012          etc

I need to delete all rows where columnA string/number matches while concatenating all potential values from Col3, Col4 & Col5 together so it looks like this

Col1(IDnum)   Col2(name)   Col3(Type)   Col4(Category)   Col(etc)
=================================================================
0011           Item          01, 02          xxj9          6B, 7B

what visual basic method would allow me to accomplish this?

thanks