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!
Bookmarks