A macro to create pivot table

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