Hi,

I'm new to VBA and this task is beyond my knowledge of VBA so any
advice would be great. I have a list of data set out like so in
worksheet 3:

1    A    N
1    B    N
1    C    N
1    D    N
1    E    Y
1    F    Y
1    G    N
2    A    N
2    B    N
2    C    Y
2    D    Y
2    E    N
2    F    N
2    G    N
3    A    Y
3    B    Y
3    C    N
3    D    N
3    E    N
3    F    N
3    G    N

I want to create a macro that will look down colunm A and if value
below matches take the value in column C and paste it into worksheet 1
and then do the same again but paste the result in column C next to the
last value each time, and continue down until the value in column A
changes then do the same again until the value changes etc.

The end result I'm trying to achieve would look something like so:

    A    B    C    D    E    F    G
1    N    N    N    N    Y    Y    N
2    N    N    Y    Y    N    N    N
3    Y    Y    N    N    N    N    N

The reason I'm doing this is because with the data vertical I have
close to 40,000 rows but by sorting it horizontally I will only be
dealing with around 2,000 rows.

Any help on this would be much aprieciated as I seemed to have spent
ages in VBA not really getting any where.

Thanks in advance for your help.