Hi everyone,

I am new in this forum and I need your help...

I have a file which contains the following data (please see attached)

Excel Forum Question.JPG

The companies and users are currently listed by row.
I need to transpose the data such that the each row contains one company and the users are listed by column.

I have 100 thousands of records so I cannot do it manually.

If you have encountered this before, please help by providing a formula or a macro program.

Hope somebody can help before Friday, 21 Sept 2012.

Thanks a lot in advance.