Macro: Transpose multiple rows into 1 column

Hello,

No previous experience with macros, so any info would be helpful.

Suppose I have names in Column A, with 4 scores in B, C, D and E. I would like to copy and transpose those scores so that they will now be in G2 to G5. However, I would like to do this for 300+ people. How can I create a macro to do this? I've tried recording a macro, but it only repeats what I've done and doesn't continue for the rest of the people.

Thank you!


e.g. Data like this:

A B C D E
Name Score1 Score2 Score3 Score4
SAM 3 4 5 6
NICK 8 7 6 5
...


To come out like this:

F G

SAM 3
4
5
6
NICK 8
7
6
5
...