I am relatively new here and would like some help (please). I will try to format the question logically.
I have a table with these Columns: RoKey (UI), MeKey (This links back to the member table), RoleType (Type of role the member has, a member may have more than 1 role).
Data can typically be like the following:
RoKey MeKey RoleType
1 Me001 Rep
2 Me001 UBS
3 Me001 OHS
4 Me002 <Null>
I would like to return in a report
Me001 Role: REP,UBS,OHS
This would be two field in an overall report.
Eseentially how do i pull out information in the same field and return it to 1 formula filed.
All help is appreciated