Breaking down a list into more.

I have been handed a hot pile of steaming yuck and need some help with the final part of it.
In the attached example you can see row 2-4 had data for 3 separate items. Column G is my achilleas heel now.
For example Col 2 needs to be broken down into 4 SEPARATE rows line 11-14.
This file sometimes will have only 1 or 30 in G so its not always going to be 4. The actual file is HUGE so its not something I would like to do manually at this point.