Database dump restructuring - Excel macro required

I have a database dump of information but it needs restructuring. It is in an Excel spreadsheet and I am happy for it to stay in this application. I can supply template of spreadsheet with column headings which match that of the database dump and then it will require a macro to take information in rows and transpose it horizontally with each new ID on a separate line A sample is provided HOWEVER PLEASE NOTE that due to confidentially clause in our contract we cannot supply the entire database dump. There are 3352 clients in our db. 3 are included in the sample data. The winner of the project will need to provide the macro to run in both excel 2003 and 2007