I want to consolidate all the rows with identical numbers in column G
but I need column L from all of the consolidated rows be totaled together when they are collapsed.
The attached file shows what I need before and after.
The information in columns F, I and K is not very important for what I need.
F and K will usually be the same value, but column I will almost always be unique for each row.
However this is handled doesn't really matter.
Can this be done with a pivot table? If so, I could really use a macro to turn it into one.
** UPDATE**
I have created a macro to format the information correctly
Now I just need the macro to convert the data to a pivot table
Bookmarks