split/group multiple columns based on primary column

I am trying to split out the ChargeType, BasisType, Rate and BillableTotal columns in to their own column so that each LoadID is only consuming one row.

For example, LoadID 52315053 would be on one row and the ChargeType, BasisType and Rate columns would be on the same row. 

The different options I have played around with are Pivot, Group and Transpose.  I am guessing I will need to use a dax calculation, but am not sure where to start.  

There are several columns between the LoadID and ChargeType, but they are all duplicated (similar to the BillableTotal and Distance columns).

See sample table at the bottom to see what I think the final results would look like.

Thanks in advance.

 Original sample table

Final Sample table.