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!