Link to home
Start Free TrialLog in
Avatar of naveenreddyinus
naveenreddyinus

asked on

Webi combining all column values in a single cell

Hello,

I have a column where I need to combine all the values into a single cell. See the picture below to understand it clearly. .
User generated image
In the picture for DeploymentID=4215, I have 3 product names EDAN, PALM-SG & SCORE in different rows. I need all 3 of them in a single cell like this:
DeploymentID      Product Name
4215                      EDAN  
                              PALM-SG
                              SCORE
4315                       FPNG
                               MYUSPTO
                               PE2E

Thanks & Regards.
Avatar of James0628
James0628

Do you really need to combine the names, or would it be OK to suppress/hide the duplicate ID's instead?  The output would look basically the same, but suppressing duplicate values may be easier than combining the values from different rows.

 Either way, I may not be able to help, since I haven't used WebI, but I thought that question might help get things started.

 James
ASKER CERTIFIED SOLUTION
Avatar of naveenreddyinus
naveenreddyinus

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of naveenreddyinus

ASKER

because its the right answer and the only way I found after no expert answered exact solution.