I have a table that looks like this and this is its markup
______________________ _____|_______|________ _____|_______|________ <table> <tbody> <tr> <td>row 1 column 1</td> <td>row 1 column 2</td> <td>row 1 column 3</td> </tr> <tr> <td>row 2 column 1</td> <td>row 2 column 2</td> <td>row 2 column 3</td> </tr> </tbody> </table>
How can I merge the entire second column into 1 cell so the table looks like this. Is it possible?
_____________________________ ________| |_________ ________|__________|_________
Copy the cell with the CONCATENATE formula (D2). Paste the copied value in the top-left cell of the range you want to merge (A2). To do this, right click the cell and select Paste Special > Values from the context menu. Select the cells that you want to join (A2 and B2) and click Merge and Center.
<table> <tbody> <tr> <td>row 1 column 1</td> <td rowspan="2">row 1 column 2</td> <td>row 1 column 3</td> </tr> <tr> <td>row 2 column 1</td> <td>row 2 column 3</td> </tr> </tbody> </table>
This should work. Any element with rowspan="2" will span two rows. you can also put colspan="2" to span columns.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With