Hello,
This is My input data
EID ENAME LOC
1111 SUMAN HYD
2222 MURALI DEL
3333 VENKAT CHN
1111 SUMAN BAN
2222 MURALI HYD
3333 VENKAT BAN
1111 SUMAN CHN
2222 MURALI MUM
3333 VENKAT PUN
my out put should be like this
EID ENAME LOC
1111 SUMAN HYD,BAN,CHN
2222 MURALI DEL,HYD,MUM
3333 VENKAT CHN,BAN,PUN
Any one please help me logic for this
please provide logic for this
Moderators: chulett, rschirm, roy
please provide logic for this
Venkat Sandu
vsandu.cg@gmail.com
vsandu.cg@gmail.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
thanks kandyshandy ' for providing logic And is there any logic to do same by using transformerkandyshandy wrote:Sort and a vertical pivot. Search here & you will find many..
Venkat Sandu
vsandu.cg@gmail.com
vsandu.cg@gmail.com
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
If you have idea , how to use pivot in excel it is mostly same like this.
viewtopic.php?t=89442
This link will help you.
Thanks
Sree
viewtopic.php?t=89442
This link will help you.
Thanks
Sree