Help a Second Noob

[wbbarn]

Hi,

I have a table in Access that currently exists as left (of attached image) and I am wanting to design a query (hopefully) that can transform the data to a new table and arranged as right (of attached image). Could anyone let me know how this can be done? UPDATE: accdb file is attached.


Thanks!

[June7]

Explore CROSSTAB query. Access has a design wizard.

[wbbarn]

Thank you, June7! I will explore crosstab queries. In the meantime, I have attached my accdb file as you suggested.

[June7]

More about CROSSTAB http://allenbrowne.com/ser-67.html

[Minty]

You can explore using a power query with transform in Excel to effectively normalise the data assuming this is a one off exercise.

[June7]

Minty, think data is already normalized. It is the first 3 columns in image. Rest of image is desired output. OP used Excel to produce this mockup but data in Access.

[Minty]

Minty, think data is already normalized. It is the first 3 columns in image. Rest of image is desired output. OP used Excel to produce this mockup but data in Access.

June - DOH! - I read it the other way around.
Left and right. Never ask me for directions...