Add column headings to row headings

[Guest]

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!

 

[Joseph Meehan]

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

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.

Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.

 

[Guest]

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