I need to reorganize the data with VBA

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!

Try this:

Please Login or Register  to view this content.

Create a second sheet called Sheet2; put these headings on the sheet
A1 = Project, B1 = Group, C1= Amount

Then run the code.