extract data from worksheet

[T3st3r]

Hi, I have a worksheet as follows:

S1 S2 S3 S4
name1 C1 C4 C3 C2
name2 C3 C1 C4 C1
name3 C1 C2 C1 C3

Is there a way of grouping the info automatically such that it shows as
follows:

S1 S2 S3 S4
C1 name1 name2 name3 name2
name3 blank blank blank

C2 blank name3 name1 name1

C3 name2 blank name1 name3

C4 blank name1 name2 blank

Thank you.