I am stuck!
I need a macro that will take the data in column A and separate it into multiple columns. The data contains company name, address, phone, fax, email (some) and Licensed states. Every company has one data point in common, the Licensed in. I need the macro to parse through Sheet 1 and place the data as shown in sheet 2 of the attached. Please help!
MS Excel 2010
Bookmarks