Moving a group of cells based on its value in a column to a different column

Hi, I have an extensive data set obtained from a eyetracking program. After cleaning the data, I get 2 columns (really long), one with the name os the stimulus (e.g. 2002.jpg) and another with the pupilsize obtained (each row represents a sample obtained). I want to break this 2 columns in a serie of adjacent columns, where every pair of columns have a different stimulus with its respective pupilsize. There are some images below explaining what I need:

parte1.jpgparte2.jpg


The number of stimulus and the number of rows for each stimulus is variable, as well as its name (but they never have the same name). Anyone can help me?

TIA,

Gabriel

Gabriel,

Here is some code that will take the data in Columns A and B of the current sheet and redistribute them per your description in a new sheet.

Please Login or Register  to view this content.

Hope that helps,

Daniel