Consolidate the rows based on duplication in some of the columns at run time

[suneel_kudana]

Hi Guys,

We have a requirement to merge the rows based on the model numbers and club specifications of all rows of a single model in a single row as shown in the image.

In the above image in Table 1, we have two different product models with different Specifications. We want to delete/hide the rows of which model number is same and show up the "Ram Size - Qty" combination (of all the rows with same model number) in a separate line as shown in Table 2. I have tried it using JavaScript in Adobe LiveCycle designer but got stuck at the initial stage itself. Even I'm unable to hide the repeating rows(for ex: here line no:2,3 and 5). Please help us with issue.