I need to reorganize the data with VBA

[baetienne]

I have data organized in a file. I want to basically have the data reorganized into a specific format/order and continue to the bottom of the list. It might be a copy/paste thing?

I need the VBA for this. I've attached an example. Thanks for the help!