Combining Records from the Same Table?

B

Brad Autry

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top