Taking non uniform data from one sheet and copying and organizing it into another sheet

Hi!

VBA noob here.

I have some php and c++ background but I have never really dealt with data sets that i had to traverse, so any code i write here would be super clunky

what i need to do is take the information in sheet 1 and copy it to sheet 2 in a useable layout

in the example i give you 2 cases, one where there is one charge and one where there are 2 charges (see ex sheet 1)
i need to take whats in sheet 1 and put it in a layout similar to sheet 2

this would be simple if the size of each (record) were identical, but they aren't they are variable with some data having 3 charges, 4 or 5.

please take a look at my example sheets and see if you can offer any advice, pseudocode or code that will help

i really appreciate your time on this and hope that i can return the favor in the future

Pl see the attached file with required macro.
Clarifications welcome.