How can I convert data from vertical format to a matrix in excel using VBA?

Hello,

I have a series of datapoints in the format seen in the tab called "Vertical format" in the attached and I need a way to transform the data into the format shown in the "Matrix" tab.

The data is transposed to have each company appear once with their corresponding datapoints appearing in different columns within the same row, not all companies have the same number of datapoints, so we would need a way to skip the blank column to ensure all datapoints are posted in the correct location.

Many thanks!