MS Excel 03 - Deleting rows that have live string identifiers in column A, while concatenating other
- by Justin
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