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. .
combine-column.png
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.
naveenreddyinusAsked:
Who is Participating?
 
naveenreddyinusConnect With a Mentor Author Commented:
Since I didn't find the solution I have concatenated the Project Name in the database itself by creating a new field.
0
 
James0628Commented:
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
0
 
naveenreddyinusAuthor Commented:
because its the right answer and the only way I found after no expert answered exact solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.