Help with Formating an excel file

[Guest]

I have a table that has the employee name above and the stats below.

For Example:

Field1 Field2
2005 - Doe, John
12/10/05 02:30:06PM

12/10/05 04:07:06PM

12/10/05 05:30:06PM

How do I get a query that displays no spaces and formatted like this:

Field1 Field2 Field3 Field4
2005 Doe, John 12/10/05 02:30:06PM
2005 Doe, John 12/10/05 04:07:06PM
2005 Doe, John 12/10/05 05:30:06PM

 

[Tom Ellison]

Dear Michael:

My suggestion is that you should write code that reads in this data,
identifies the various types of rows in the spreadsheet, and, where
appropriate, writes out a row to a table.

What you have now seems to be organized, but it is not a table. There's not
anything I'd recommend trying in terms of a query.

Tom Ellison