Hi
I have a worksheet in excel 2010 that has approx. 50k rows of data (I have attached a preview of the worksheet). I am looking for a way to run VBA to basically append the "Material Description(Long Text) into one cell where the unique key matches in column A "Material"
I need to find a way to loop through column A and where the values are the same append the Long text in column B to the first record found and then delete the rows that have appended.
This is a data export from SAP and I need to arrange it into the above format to load into our company asset management system.