Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

Add column headings to row headings

Discussion in 'Information Technology' started by nandan, Nov 1, 2005.

  1. nandan

    nandan
    Expand Collapse
    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!
     
  2. Loading...


  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    nandan wrote:
    > 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.

    >
    > 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

    Dia duit
     
  4. nandan

    nandan
    Expand Collapse
    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?

    "Joseph Meehan" wrote:

    > nandan wrote:
    > > 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.
    >
    > >
    > > 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
    >
    > Dia duit
    >
    >
    >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page