combine same values three columns

[cnu_753]

Hi,
Actually I am working with excel since 5yrs but very new to <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">vba</acronym> and very interested to learn also. Please find the following post

[TABLE="class: cms_table, width: 195"]
<tbody>[TR]
[TD="colspan: 3"][TABLE="class: cms_table, width: 195"]
<tbody>[TR]
[TD="colspan: 3"]DATA[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]LHS[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3[/TD]
[TD]LHS[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]RHS[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]5[/TD]
[TD]RHS[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]LHS[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

and my result will be like this

[TABLE="class: cms_table, width: 195"]
<tbody>[TR]
[TD="colspan: 3"]RESULT[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]3[/TD]
[TD]LHS[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5[/TD]
[TD]RHS[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]6[/TD]
[TD]LHS[/TD]
[/TR]
</tbody>[/TABLE]


Kindly give <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: rgb(0, 0, 0); border-left-color: initial; border-image: initial; cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> for this.
Thanking you

 

[cnu_753]

Thanq Mr.Mick........ really working superb..... thanq

 

[MickG]

You're welcome