Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rotate data in table?

    I have imported data from Excel and I need it to be rotated. Currently across the top are store names and the first column is job titles.
    I want the store names in the first column and the job titles to become the row headers.
    Can this be done?
    There is always a way.

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rotate data in table?

    You can transpose the data in Excel. Copy the data, then click Edit/Paste Special and check the Transpose checkbox. Once you have it transposed in Excel, you can import the worksheet to Access and it will be "rotated".
    HTH

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Rotate data in table?

    What exactly are you trying to do?

    Data in Access isn't quite the same as what you have in Excel. What you see at the top of an open table is the name of the fields/columns. That much is the same. But what you see in the left column of a table is the value for the first field each record. This is not quite comparable to row headings in Excel.

    What you're describing is a flat file, and there's no point in doing that in Access. You would not ordinarily have a table with a separate field for each store name and a row for each job title. Instead, you would have a table of job titles and a table of stores. Then if you wanted to indicate that certain job titles existed in certain stores, you would create a third table that had a record containing a field for the Job title key (not the name of the job title) and a field for the Store ID (not the name of the store). If you wanted to get something that looked like your Excel file, you would do that with a query on the three tables.

    If you explain more about what you're trying to accomplish, we can help you get to a relational design that will work better and can grow when it's necessary.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •