Transposing data...bit complicated

**kilantro** · 02-02-2011, 10:26 PM

Hi all,

I am going bananas trying to manully transpose my data....surely there is a way to macro it?!?

My data looks like this:

A 123
A 456
A 789
B 987
B 654
C 321
C 147
C 369
D 564

and it needs to get to....

A 123 456 789
B 987 654
C 321 147 369
D 564

I will kiss the feet of anyone who can help me!!!
I have over 3000 lines to do EEK!

**stanleydgromjr** · 02-02-2011, 11:02 PM

kilantro,

Welcome to the Excel Forum.

I assume that your raw data is in columns A and B, and that your first A is in cell A1.

I have utilized columns D, E, F, and G, for the output.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Then run the ReorgData macro.

**kilantro** · 02-02-2011, 11:29 PM

THANKYOU!!!!!
Let the feet kissing begin!
That worked like a charm - can't say how much I appreciate your help enough!

**pike** · 02-03-2011, 03:45 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save