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