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.
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.