Hi,

I would like some help solving the following problem. I have a list of companies in a report and I would like to make a new table with the same information but arranged differently. What kind og formula should I use? Please see attached example.

Excel.xlsx