Convert row data in html table with 3 columns code

a3des

New Member
Joined
Feb 19, 2020
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Hello!
I'm struggling with a task that is above my knowledge. I have a huge table like this example below:

idhtml codemodelmodelmodelmodelmodelmodel
1.10.M1007<tr><td>Asus M6 Serie</td><td>Asus M6000</td><td>Asus M6000 Serie</td></tr><tr><td>Asus M6000A</td><td>Asus M6000C</td><td>&nbsp;</td></tr>Asus M6 SerieAsus M6000Asus M6000 SerieAsus M6000AAsus M6000C
1.10.M1008Asus M6 SerieAsus M6000Asus M6000 SerieAsus M6000AAsus M6000C
1.10.M1009Asus M7AAsus M7VAsus Mobile Neon IIAsus Mobile Neon II-SAsus Mobile Neon II plusAsus Mobile Neon II+
1.10.M101Satellite 1200Satellite 1200-S121Satellite 1200-S122Satellite 1200-S252Satellite 3000-100Satellite 3000-214
1.10.M1010Asus F70Asus F70sAsus F70slAsus G71Asus G71gAsus G71G-A1
1.10.M1011Clevo M72Clevo M72XClevo M72XRClevo M72XSClevo M72XSRClevo M72XT
1.10.M1012Asus M9 SerieAsus M9AAsus M9FAsus M9JAsus M9V
1.10.M1013Asus M9 SerieAsus M9AAsus M9FAsus M9J
1.10.M1014Advent 9915wEasyNote MZ45

Is there a way to select all used cells right to "html code"column and generate a html table code with 3 columns in the empty cell of "html code" column like I exemplified in the first row?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Forum statistics

Threads
1,224,824
Messages
6,181,187
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top