Results 1 to 3 of 3

Formula to copy rows of data from one page to another multiple times

Threaded View

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    Bournemouth, England
    MS-Off Ver
    2010
    Posts
    2

    Formula to copy rows of data from one page to another multiple times

    Hi, if anyone can help with this data from my Psychology dissertation experiment I'd really appreciate it.

    I'm basically trying to work out a formula to paste entire rows of data multiple times from one page into another.

    The first page is the "trial index", this lists information about the appearance of a stimulus that appeared on the sceen. For example it will say whether a photo appeared, which direction a "target" appeared etc.

    The second page has the eye movement data for each trial. There are the same number of trials. However there is an individual row for each eye movement within a trial, resulting in a lot more data. So hopefully you'll see that there were 2 eye movements for trial 1, 3 eye movements for trial 2 etc.

    The third page of the spreadsheet shows what I'm trying to achieve. I basically want to repeat the "trial index" information next to each relevant eye movement. This means that each "trial index" row can appear multiple times, depending on how many eye movements there were.

    I'm trying to find a formula to achieve this without copying and pasting the data for every trial as I have 24 of these spreadsheets to complete.

    I really hope this makes more sense when you look at it and if you can help at all then you're my hero!

    Thanks so much!
    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