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

[iamcalledjosh]

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!

[ConneXionLost]

Assuming the layout will remain the same, in cell A2 of the "Example of complete spreadsheet" tab, use:

Please Login or Register  to view this content.

Autofill across and down.

Note - If the ranges are a different size, you'll need to make the necessary adjustments.

[iamcalledjosh]

This is great, thank you so much! I'm terrible at excel and this has saved me hours of work