Records flow in a table

Database

Records flow in a table

Greetings,

Have scenario Column1 (C1) and Column2 (C2)  the combination  of C1 & C2 will be unique, but C2 value will be repeated on C1 - for that particular  row will have another value in C2 the requirement here is to  display the C2 value in C3.

Example: ‘S2’ is a value in C2 but ‘S2’ is repeated on C1 and corresponding value in C2 for ‘S2’ is ‘S8’ I would like to display ‘S8’ in C3 as value next to ‘S2’. L

Coloumn1

Coloumn2

Coloumn3

S1

S2

S8

S3

S4

S9

S5

S6

S2

S8

S4

S9

I would greatly appreciate any ideas!

Thanks,

EP