I have thousands and thousands of rows of data which look like the spreadsheet screen shot shown in this image:

ExcelConsolidateRaw.JPG


I want to consolidate them so that they look like the spreadsheet screen shot shown in this image:

ExcelConsolidateDesired.JPG

I used to have a macro/VBA code that would do this, but lost it sometime over the years. Does anyone have code that will do that? (I'm a novice and do not know how to write it; only how to insert it into a module in the VBA editor).

Thank you for your help!