Results 1 to 4 of 4
  1. #1
    brianrunsphilly is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2013
    Posts
    2

    transposing data in a report

    I know this has been asked before but I am still struggling. I have a set of data in which I want to transpose rows and columns for the report. It is of this format in the table, and in the report I would like the columns to be patient ID's and the rows to be BRCA1, BRCA2, PALB2, RAD52, PARP1, PARP2.



    Patient ID BRCA1 BRCA2 PALB2 RAD52 PARP1 PARP2
    SJTALL001.ETP -8.89873 -6.595905 -3.890829 5.4208493 -6.295533 -9.2605734
    SJTALL002.ETP -1.9037342 -2.0763407 -6.8788815 -4.410863 11.15449 1.2569857
    SJTALL005.ETP -2.9297638 -7.7500105 -1.8912506 -1.75654745 0.36532402 6.326957
    SJTALL009.ETP -10.860171 -3.063228 8.4301805 2.42634487 7.227287 2.8921556
    SJTALL010.ETP -2.9476643 0.11965513 -1.014266 2.3000331 3.7024355 2.511487
    SJTALL011.ETP 11.24115 2.5265455 6.1173105 3.3252358 0.0630817 2.1886587

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Why do I feel like I am looking at an Excel spreadsheet?

  3. #3
    brianrunsphilly is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2013
    Posts
    2
    That's what the table looks like in Access 2007 when I pasted it here.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    Well the structure seems to be that of a spreadsheet. This data may very well belong in one or two tables. Maybe you can make a few excell workshhets, paste the data using "Paste Special". Use a different "Special" for each worksheet.

    Then you can delete some data/columns from each worksheet. DElete data in a way that you begin to segragate items like PatientId, BRCA, PARP. In the end, the data will make many rows/records where PatientId, BRCA, PARP are field names in the header.

    Then, you can start importing your worksheets into a normalized data structure. Use an AutoNumber in Access to create primary Keys.

    I really don't know how to explain the importance of table structure. Perhaps before you begin, you can do some research on normalization, data table structure, RDBMS, DBMS

    Maybe this will get you started
    https://www.accessforums.net/access/...orm-31015.html

    You can definately post yourquestions here. I am not trying to stear you away.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 10
    Last Post: 08-29-2013, 09:21 PM
  2. Transposing Columns to Rows
    By hycho in forum Programming
    Replies: 5
    Last Post: 07-19-2012, 01:17 AM
  3. "transposing vertical data into horizontal columns"
    By stevelondon in forum Queries
    Replies: 3
    Last Post: 03-20-2012, 12:36 PM
  4. Replies: 1
    Last Post: 03-07-2012, 09:00 AM
  5. Transposing Data
    By NoiCe in forum Queries
    Replies: 0
    Last Post: 11-09-2008, 05:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums