This macro will convert your table into a consolidated version.
============
How to use the macro:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet
The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
This macro is designed without the BEFORE row, so it expects your titles to be in row 1 and your first row of data in row 2, plot numbers in column A. Sample attached.
Bookmarks