I have an excel spreadsheet representing data of customers. The current
layout lists all the information vertically, with the descriptor in column
A, and the relative info in column B. Here is a sample of the data
currently in the spreadsheet:
Column A / Column B
Row 1 Name: / Steve Jones
Row 2 Job Title: / Owner
Row 3 Company: / Acme Sprockets
Row 4 Telephone: / 555-1212
Row 5 Name: / Joe Black
Row 6 Job Title: / Sales
Row 7 Telephone: / 555-1313
Row 8 Name: / Jane Doe
Row 9 Telephone: / 555-1414
etc....

There are 7 possible descriptors, and for those customers whose info is not
provided relative to a descriptor, has been left out, leaving some disparity
in the data.

What I need to do is transpose the data into a standard layout, whereas the
customers are listed row by row, and the descriptors are moved horizontally
as column headers. I have no clue how to proceed. At my disposal is SQL
Server 2000 and ColdFusion, where maybe this data could be imported, but
again, I don't know how to proceed. I would like the data to look something
like this:

Column A / Column B / Column C / Column D
Row 1 Name / Job Title / Company / Telephone
Row 2 Steve Jones / Owner / Acme Sprockets / 555-1212
Row 3 Joe Black / Sales / <blank / 555-1313
Row 4 Jane Doe / <blank / <blank / 555-1414

Any help would be appreciated.