Macro: Transpose multiple rows into 1 column [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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
...



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
That macro is a template. You would need to make it flexible.
How would I make it flexible? I don't know anything about macros, I just know they exist!
Thanks!
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Could you post your current macro

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!