Rows of Users to rearrange in Columns

**dgdamay** · 09-18-2012, 05:32 AM

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.

**arlu1201** · 09-18-2012, 05:34 AM

It will be good if you post a sample excel file. The png will not help.

**dgdamay** · 09-18-2012, 06:10 AM

Thanks.
I have attached a sample Excel file.

**arlu1201** · 09-18-2012, 07:28 AM

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button