Merging Rows of data dynamically.

[prasathrk]

Hi

I am having the following requirement.

my recordset is as below,

col1  col2  col3  col4
-------------------------------
a1     a2      a3    a4
b1     b2      b3    b41
b1     b2      b3    b42
c1     c2      c3    c4
 

I have to build a html table dynamically in ASP as below,

col1  col2  col3  col4
-------------------------------
a1     a2      a3    a4
b1     b2      b3    b41
                         b42
c1     c2      c3    c4
 

2 and 3 rd row should be merged (rowspan=2). Only the 4th column may contain multiple values. For those multiple values, other colmns shd be merged.

How to do it? Any help will be highly appreciated...

<email removed>

[jhardman]

you are going to need to pull up one record and compare it to the next row before you print it. if those three columns are equal, then merge the table cells. The HTML is easy, but I can help with that too if you want.

Jared