Re: Help with Formating an excel file

Dear Michael:

My suggestion is that you should write code that reads in this data,
identifies the various types of rows in the spread***, 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


"Michael" <Michael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3084F9C2-33BB-4276-B86E-0A829F6FC308@xxxxxxxxxxxxxxxx
>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


.