Add column headings to row headings

N

nandan

I have a spreadsheet that has account numbers for rows and dates for
column headings. Example:

ACCOUNT NUM 8/1/03 9/1/03 10/1/03 thru 8/1/05
1234 10 10 20 other
values
5678 1 2000 30

I want it to look like this:
Account Num Date Value
1234 8/1/03 10
1234 9/1/03 10
1234 10/1/03 20
5678 8/1/03 1
5678 9/1/03 2000
5678 10/1/03 30

I'm at a loss what to do!

Thanks!
 
N

nandan

I have imported this spreadsheet into MS Access 2000 to try to accomplish
what I want to do. Can this be done in Access?
 
Top