I have a report that I would like to have one field merge data into one record per employee when there is multiple values in that field.
For example:
Field: Employee Name - Jane Doe
Field: Degree - Bachelors of Science
- Bachelors of Art
Would like it to look like this where Degree field merges values per employee
Jane Doe - Bachelors of Science, Bachelors of Art
Some employees will have only one others may have several, how would i do this?
Thanks for any help on this.
For example:
Field: Employee Name - Jane Doe
Field: Degree - Bachelors of Science
- Bachelors of Art
Would like it to look like this where Degree field merges values per employee
Jane Doe - Bachelors of Science, Bachelors of Art
Some employees will have only one others may have several, how would i do this?
Thanks for any help on this.