How to impliment this logic?

[nareshketepalli]

My source tables are like
Source 1 table data source 2 table data

cust_id cust_id
1 6
2 7
3 8
4 9
5 10
6 11
7 12
8 13
9 14
10 15

and i want to impliment like..........


target table

x 1 2 3 4 5
y 6 7 8 9 10
z 11 12 13 14 15


any suggestions.........

Thanks,

[chulett]

Suggest you explain in words how you get from that input to that output. What is your business rule?