Convert a crosstab set of data to a flat list

[jamesrees02]

Hi,


Need to try a solve a problem. I have a set of data in excel (100k+ rows) that I have imported into an access table. The problem with the data is that there are 12 columns for the months and I want this in a list format to import into another application.
e.g.
I have:
Product, Jan, Feb, Mar, Apr, May, Jun, Jun, Jul, Aug, Sep, Oct, Nov, Dec
ProdA, 0,0,0,0,0,0,100,0,0,0,50,0
Prodb, 100,0,0,0,0,0,0,0,0,0,0,0
Prodc, 0,0,10,10,10,0,0,0,0,0,0,0

but I want it to look like this:
Product, Month, Amount
ProdA, 7,100
Proda, 11,50
Prodb,1,100
Prodc, 3,10
Prodc, 4,10
Prodc, 5,10

Is there some function in Access2010 to do this or will I need to write 12 select queries with a union?

Thanks in advance!

[June7]

One SQL with UNION:

SELECT Product, "Jan", As [Month], [Jan] As Amount FROM tablename
UNION SELECT Product, "Feb", [Feb] FROM tablename
...;

Do you need year?

[jamesrees02]

No need for year as its all 2012.

Thanks for confirming.
James

[June7]

If this data is the result of a crosstab, what is the original data structure? Could an aggregate (GROUP BY) on the original data produce the output?