Transpose Column data into Row data

Hi,
My table is in access, and I need help in transposing the following format:
Lodge#   Year    Jan   Feb   Mar   Apr
1            2007     10     15    12      20

Into this:
Lodge#    Year    Mo       Amount
1             2007     Jan            10
1             2007     Feb            15            
1             2007     Mar            12
1             2007     Apr            20

Do you know of the code that would do this transpose?Start Free Trial