Consolidating non-identical lists

[cat2006]

Hello!

I have a bunch of supplier information (company name, sales, products, customers, etc) listed in a long vertical array. I would like to create a matrix with column headings (company name, sales, products, customers, etc) running aross the board and supplier information down the rows. However, the number of fields per supplier varies, and I am at a loss of how to solve this.

Would anyone know how to do this? I have attached a sample of my data here. Under "Given" you will find the long vertical array and under "Want" is an idea of the matrix that I would like to end up with.

Thank you

Catarina