I am looking to have a macro or similiar function written which can convert excel files of contact information in which name, address, phone and email appear vertically (rows) into excel or csv files in which name, address etc are distributed horizontally (columns). All contact information will be seperated by spaces/blank rows vertically. there will be no blank rows within a contact so you can use the presence of a empty row to define an object. however not all contacts will contain the same number of rows but specific information, if it is available MUST be distributed to a specific column. For example some contacts may have an email address followed by a phone number, others may have just a phone number. In both cases the phone number must end up in the far column.
this is something which is better shown by examples--if you think that you might be interested I can provide some.
## Deliverables
Will define in consulatation with you I am willing to pay for things which don't quite meet my needs if they represent progress
## Platform
windows vista is the current thought, VBA but that is flexible