How to combine two rows of text data into a single column in OTBI?

**This post was created as part of a How to Service Request (SR)

Release:

11.13.22.07.0

Summary of the question:

How to combine two rows of text data into a single column in OTBI?

For example:

Employee XYZ has two degrees B.Tech and M.Tech the analysis has to print in the format as below:

Employee Degree:

XYZ Bachelor's Degree,Master Information Systems