Hi guys and anticipated thanks for the help:

Let me try describe the data first.
Worksheet 1:

C1 C2 C3 .... C8
M2 M3
M2 M20
M2 M31
M5 M4
M5 M10
M5 M13


To describe it: Column1 contains a value which may repeat...Column 8 has unique values which correspond to the content in Column 1. The "Ms" are random.

Worksheet 2:

C1 C2 C3 C4 C5 C....
M1
M2
M3
M4
M5
...
M50
M51
M52
...
M99
M100
...


Explain what my macro needs: Has to go through C1 of Worksheet 1and for each M should copy-paste transpose the values from C8 into worksheet 2 C2, C3 (whatever is needed)

in other words, Worksheet 2 should look like this:

C1 C2 C3 C4
M1
M2 M3 M20 M31
M3
M4
M5 M4 M5 M13
M6
M7
...


Many thanks in advance. MUCH MUCH appreciated