Unable to create macro due to varying data

If anyone could help me with this, I would be very appreciative! I'm trying to figure out a macro to rearrange some data, however, it varies from item to item so I am unable to simply use text to columns or a cell offset to do the rearranging. I have attached an example for your review. Please let me know if I can provide any additional information.