Can you create a crosstab like query but return all rows? 1

[jeanna143]

I have a table that is a repetitive list of data. Instead of having a column with rows of data underneath we have Column A listing over and over what should be the column headings and then the corresponding data is in Column C.

For Example:
Name John Doe
Address 1234 street
***
Name Jane Doe
Address 1235 Street
***

What I need to do is Make the table look like this:
Name Address
John Doe 1234 Street
Jane Doe 1235 Street

I tried using a CrossTab query and a Pivot table but they only will return either a count or the first or last row, etc. How can I convert this table and return all rows?

Thank you!!
Jeanna

 

[jeanna143]

You deserve the star. This is great. You and I did work well together. Sometimes people reply kind of rude or you just can't understand what they wrote. I appreciate your patience and clear descriptions.

Now I will just be working on cleaning up some formatting. I think they used every possible method of formatting a telephone number in this contact list... LOL.

I will be sure to contact you in the future if I have trouble.

Thanks again!!
Jeanna