hi all,
i have data in worksheet in tabular format like
<TABLE dir=ltr borderColor=#05ad00 cellSpacing=1 cellPadding=2 width=269 border=1><TBODY><TR><TD width="25%" height=16>
i want to keep all workers name in one cell seperated by comma and remove remaining two rows. the output data should look like -
<TABLE dir=ltr borderColor=#02ad00 cellSpacing=1 cellPadding=2 width=283 border=1><TBODY><TR><TD width="24%" height=16>
thanks in advance
i have data in worksheet in tabular format like
<TABLE dir=ltr borderColor=#05ad00 cellSpacing=1 cellPadding=2 width=269 border=1><TBODY><TR><TD width="25%" height=16>
JobName
</TD><TD width="25%" height=16>JobType
</TD><TD width="25%" height=16>Machine
</TD><TD width="25%" height=16>Worker
</TD></TR><TR><TD width="25%" height=16>A
</TD><TD width="25%" height=16>J1
</TD><TD width="25%" height=16>M1
</TD><TD width="25%" height=16>xyz
</TD></TR><TR><TD width="25%" height=16>A
</TD><TD width="25%" height=16>J1
</TD><TD width="25%" height=16>M1
</TD><TD width="25%" height=16>wxy
</TD></TR><TR><TD width="25%" height=16>A
</TD><TD width="25%" height=16>J1
</TD><TD width="25%" height=16>M1
</TD><TD width="25%" height=16>pqr
</TD></TR></TBODY></TABLE>i want to keep all workers name in one cell seperated by comma and remove remaining two rows. the output data should look like -
<TABLE dir=ltr borderColor=#02ad00 cellSpacing=1 cellPadding=2 width=283 border=1><TBODY><TR><TD width="24%" height=16>
JobName
</TD><TD width="24%" height=16>JobType
</TD><TD width="24%" height=16>Machine
</TD><TD width="29%" height=16>Worker
</TD></TR><TR><TD width="24%" height=16>A
</TD><TD width="24%" height=16>J1
</TD><TD width="24%" height=16>M1
</TD><TD width="29%" height=16>xyz,wxy,pqr
</TD></TR></TBODY></TABLE>thanks in advance