Combining Records from the Same Table?

Pardon me if this has been posted previously, or if this is in the wrong forum.

I have one table with records that are somewhat repetitive, however one
field within the record varies. I would like to "clean up" the table.

Here is a simplified example of what I am working with:

ID Name Number Question Response
123 John Smith 123 Age 32
123 John Smith 123 Gender Male

I would like the table to be:

ID Name Number Age Gender
123 John Smith 123 32 Male

It seems like something that should be so very easy, but I'm a bit rusty on
Access and the answer is not coming to me, outside of exporting the data to
Excel and doing things manually.

Thank you ahead of time for your assistance.

Check out crosstab queries in Help. It could be just what you need.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Brad Autry" wrote:

Pardon me if this has been posted previously, or if this is in the wrong forum.

I have one table with records that are somewhat repetitive, however one
field within the record varies. I would like to "clean up" the table.

Here is a simplified example of what I am working with:

ID Name Number Question Response
123 John Smith 123 Age 32
123 John Smith 123 Gender Male

I would like the table to be:

ID Name Number Age Gender
123 John Smith 123 32 Male

It seems like something that should be so very easy, but I'm a bit rusty on
Access and the answer is not coming to me, outside of exporting the data to
Excel and doing things manually.

Thank you ahead of time for your assistance.