Moving data from a row to column based on dup

I don't have 2010 so I'm not sure on in being compatible, but my guess should work the same.

Sorry I forgot to attach the workbook

•Highlight macro >> press >> CTRL + C
•Open your workbook
•Press >> ALT + F11 >> opens the Visual Basic Editor (VBE)
•Press >> ALT + I >> activates the Insert menu
•Press >> M >> inserts a Standard Module
•Paste code >> CTRL + V (right side of screen)
•Press >> ALT + Q >> exits VBE and returns to Excel
•Run the macro >> press >> ALT + F8 >> displays Macro Dialog Box. Highlight macro >> select Run.