Results 1 to 6 of 6

Odd Transpose Query - likely requiring VBA solution

Threaded View

rodwhiteley Odd Transpose Query - likely... 09-14-2012, 06:15 AM
arlu1201 Re: Odd Transpose Query -... 09-14-2012, 06:33 AM
rodwhiteley Re: Odd Transpose Query -... 09-14-2012, 07:05 AM
arlu1201 Re: Odd Transpose Query -... 09-14-2012, 07:10 AM
rodwhiteley Re: Odd Transpose Query -... 09-14-2012, 07:29 AM
arlu1201 Re: Odd Transpose Query -... 09-14-2012, 07:30 AM
  1. #1
    Registered User
    Join Date
    09-14-2012
    Location
    Doha, Qatar
    MS-Off Ver
    Excel 2010
    Posts
    6

    Exclamation Odd Transpose Query - likely requiring VBA solution

    Hey,
    I am trying to transpose some data for a repeated measures study we are doing.
    I have a series of variables that are measured on one occasion each by two different raters.
    This data is currently arranged in columns as follows:

    "Subject No" , "Rater" , "Variable1" , "Variable2" , ... i.e. total columns = 2 + number of variables

    Subject Rater Var1 Var2 Var3
    Number
    1 1 12 16 19
    2 1 20 17 16
    3 1 10 10 20
    1 2 10 12 14
    2 2 10 16 18
    3 2 15 18 17

    I would like to transpose this so that I end up with the data organised into 4 columns (only):

    "Subject Number" , "Rater" , "Variable No" , "Measure"

    Subject Rater VarNo Measure
    Number
    1 1 1 12
    1 2 1 10
    2 1 1 20
    2 2 1 10
    3 1 1 10
    3 2 1 15
    1 1 2 16
    1 2 2 12
    2 1 2 17
    2 2 2 16
    3 1 2 10
    3 2 2 18
    1 1 3 19
    1 2 3 14
    2 1 3 16
    2 2 3 18
    3 1 3 20
    3 2 3 17

    For a few variables & subjects this is trivial copy & paste, but I have 103 variables with 100 subjects and 2 raters, so I will make a mistake for sure doing this manually (and go mad into the bargain).
    I have attached a sample sheet showing the some dummy input data in the range A1:E7 and the desired output in H1:K19 (3 subjects, 2 raters, 3 variables) as I doubt the copied and pasted data above is very clear.
    Thanks in advance for any help,
    Rod
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1