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!

Welcome to the forum.

With formula it goes like that:

Formula:

Please Login or Register  to view this content.

Originally Posted by Gerardo.Cantu

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

If you would like to use the excel functionality also (i.e. a mixed method) for this purpose (VBA solution), and not just VBA itself, then the basis of operation will be (as a primary consideration) appropriate data sorting - it will form the basis for all other data operations.

vba

Please Login or Register  to view this content.