Logic required

[subbareddykm]

HI All ,

I have been trying on below data to get required output since long time.

I have data like below :

Field
User : Kalyan
Loc:
City
Dest
Code
1001
1002
1003
1004
1005
1006
1007
User : Ravi
Loc:
City
Dest
Code
2001
1007
1004
User : Shiva
Loc:
City
Dest
Country
Code
2008
2010
2003
3289
3892
8221

I want output like below :

User	Code
Kalyan	1001
Kalyan	1002
Kalyan	1003
Kalyan	1004
Kalyan	1005
Kalyan	1006
Kalyan	1007
Ravi	2001
Ravi	1007
Ravi	1004
Shiva	2008
Shiva	2010
Shiva	2003
Shiva	3289
Shiva	3892
Shiva	8221

Can anyone tell me how to achieve this in back end?

!

[YoussefBelloum]

Hi,

what is the rule to map the codes and the users ?

[trdandamudi]

May be as below: