I need a simple excel macro to be created

I have a load of data that needs reformatting. A simple macro will be able to do this and is what I am looking for.

This is a 2 minute job for the person who knows how to write macro's.

I would like the macro sent back with the spreadsheet