You will want to export the spreadsheet to an Excel workbook and create a pivot table, then place an empty cell above each company name, then use a macro to take all of the data below each individual company name and transpose it into columns to the right of the data. I will attach the macro you will need to use as a text file.
|