Macro that can transpose and roll up identical items

[rominjn]

Hello,

I need help writing a macro from scratch that can copy data from one sheet and then paste them in another sheet but with two transformations: the pasted data needs to transpose the horizontal raw data into a vertical arrangement AND roll up records that are identical. Ideally, the macro runs and updates automatically after someone hits Save or Save As on the file.

I've attached a sample Excel file of what the results should look like. Normally, I would share the macro that I've started writing as a starting point but I don't even know where to start with this particular task. Any help would be greatly appreciated.

Danny

[MickG]

Try this:-
Results on "Results sheet" starting "A1"

Please Login or Register  to view this content.

Regards Mick

[jindon]

Flexible to increase/decrease of number of score columns.

Please Login or Register  to view this content.

[rominjn]

Thanks Mick. This worked!