Macro to compile a list with multiple columns

Hello,
I have a list which contains three columns (see attached workbook).
I need a macro to generate a compiled list counting each item and list next to it the corresponding "Length" and "Width".
It has to be a macro, not formula or pivot table, because this is just a part of a more extensive routine.
Could anybody advise please?
Thank you

Here's a quick and dirty solution. It temporarily uses the empty column D to keep track of which items in the list its already accounted for. (I mark the item with an "x" in column D.) Afterwards, I erase it, of course.

It seems to work as intended. It duplicates your intended output exactly. Modify as needed.

Please Login or Register  to view this content.