Hi all hope some super whizz can help me with this.
I have 2 spreadsheets which show company name, address, phone, fax, email and also certification. Each of the spreadsheets is a different certification but the same company can appear twice. Is it at all possible to combine the two spreadsheets and if a duplicate is found it uses one record but can add the other certificate in a cell next to it or in the same cell sperated by a comma? Anything like this basically. I have a few thousand rows and doing it manually is very very hard and hurts my head. Any help would be amazing. I don't know whether theres a guide or video or anything in the world to help me with this but I just need to be able to merge the records and add the certificate if one has both.
To clarify the columns are the same (or very similar and can make them as such) just the certification type is different. One is called WBE and one is called MBE.
Again any help much appreciated.
Bookmarks