Transposing Data from Horizontal to Vertical

**OTexcel** · 11-16-2012, 06:58 PM

I currently have a spreadsheet that is 1 row per user with their data entered in columns.

Example:

User 1 Value 1 Value 2 Value 3
User 2 Value 1 Value 2 Value 3

How can I get the data to display as:
User 1 Value 1
User 1 Value 2
User 1 Value 3
User 2 Value 1
User 2 Value 2
User 3 Value 3

Thank you in advance!

**Steve N.** · 11-16-2012, 07:18 PM

Can you attach a sample spreadsheet? How many users and values are you working with?

**jeffreybrown** · 11-16-2012, 07:53 PM

You can try this macro which will begin pasting the results in A20.

Please Login or Register  to view this content.

Place in normal module

Highlight macro to copy >> Ctrl + C >> Open your workbook
Alt + F11 >> opens the Visual Basic Editor (VBE)
Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
Insert menu >> Module or Alt + I, M >> activates the Insert menu and inserts a Standard Module
Paste code >> Ctrl + V (right side of screen)
Alt + Q >> exits VBE and returns to Excel
Back in Excel to run the macro >> Alt + F8 >> Macro Dialog Box >> Highlight macro >> Run