Need help making VBA to transpose and delete duplicates

[pluqk]

Sample Workbook.xlsxI need a VBA that can delete redundancies and transfer the second score (if there is one) over to another column. Here is an example.

Before_Macro

Name___________ID_____Loc____Score
Mark_B.________1223___NY_____3
Mark_B.________1223___NY_____2
Anthony_M._____3200___LA_____1
Anthony_M._____3200___LA_____4
Ben_A._________1101___HO_____2
Ben_A._________1101___HO_____3
Elizabeth_S.___2600___NY_____2
Christina_G.___4206___LA_____3
Christina_G.___4206___LA_____6
Daniel_F.______9880___NY_____3


After_Macro

Name___________ID_____Loc____Score_1___Score_2
Mark_B.________1223___NY_____3_________2
Anthony_M._____3200___LA_____1_________4
Ben_A._________1101___HO_____2_________3
Elizabeth_S.___2600___NY_____2___
Christina_G.___4206___LA_____3_________6
Daniel_F.______9880___NY_____3


Please help!

[TMS]

Please post a sample workbook.

Regards, TMS

[kalak]

try

Please Login or Register  to view this content.

[pluqk]

that worked amazingly well, thank you

[TMS]

Late entry ... alternative approach

Please Login or Register  to view this content.

Regards, TMS

[xladept]

And yet another

Please Login or Register  to view this content.

[TMS]

Posts #3 and #6, truly impressive. Sadly, there's no way on God's earth that I could understand, explain, replicate or maintain those routines. Think I'll stick with the basic stuff. I'm not going to be developing apps for OS or Android any time soon either

Edit: changed Post #5 (mine) to read Post #6 (xladept's) as per Post #8

@xladept: no, seriously, not a clue.

[xladept]

@ Trevor - Post #5 is yours


And - who do you think you're kidding

[xladept]

@ Trevor,

there's no way on God's earth that I could understand, explain, replicate or maintain those routines

All I did was to use the Worksheet array and resize it so that the new columns would fit