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?
!
