Hi,
With a FOR EACH loop, I need to create a Comma Delimited List From a Column. For example, from the following data:
MemberID Team FirstName
1 1 Jim
2 1 Mary
3 1 Bob
4 2 Sue
5 2 Ralph
6 2 Ellen
7 3 Bill
8 3 Linda
the desired output is a list of Teams and Team members, in the form of:
Team Members
1 Bob, Jim, Mary
2 Ellen, Ralph, Sue
3 Bill, Linda
Any helps anybody can give would be very much appreciated.
Thanks in advance
With a FOR EACH loop, I need to create a Comma Delimited List From a Column. For example, from the following data:
MemberID Team FirstName
1 1 Jim
2 1 Mary
3 1 Bob
4 2 Sue
5 2 Ralph
6 2 Ellen
7 3 Bill
8 3 Linda
the desired output is a list of Teams and Team members, in the form of:
Team Members
1 Bob, Jim, Mary
2 Ellen, Ralph, Sue
3 Bill, Linda
Any helps anybody can give would be very much appreciated.
Thanks in advance