Skip to Content

Dynamically Merging Columns in a table

Hello All,

Is it possible to merge columns in table based on some set of condition.

The current output is as follows:

Column 1 Column 2 Column 3 Column 4 Column 5

Row1 "" "" "" ""

SubRow1 "" "" "" ""

Value 1 Value 2 Value 3 Value 4 Value 5

The output which we need is as follows:

Column 1 Column 2 Column 3 Column 4 Column 5

Merged Row 1 (merged columns)

Sub Row 1 (merged columns)

Value 1 Value 2 Value 3 Value 4 Value 5

Merged Row 2 (merged columns)

Sub Row 2 (merged columns)

Value 1 Value 2 Value 3 Value 4 Value 5

Merged Row 3 (merged columns)

Sub Row 3 (merged columns)

Value 1 Value 2 Value 3 Value 4 Value 5

Thanks.

Kiran

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 05, 2009 at 08:12 AM

    The merge is simple if you do not think about it as in word:))

    The merge can be done using scripting: just concatenate the values of the fields into one variable, fill in the value to the first column, change its width (to the width of the previous 4 cols) and hide te remaining/ blank cols.

    Have fun, Otto

    Add comment
    10|10000 characters needed characters exceeded