I hope you will be able to help me on this.

I have a Data Sheet from one of my suppliers which has a list of multiple specifications for different products. Like below:

ModelNo ItemNumber Col_1 Col_2
10000ES 1 Model No: 10000ES
10000ES 2 Capacity: 10tonne
10000ES 3 Minimum Saddle Height: 170mm
10000ES 4 Maximum Saddle Height: 576mm
10000ES 5 Maximum Chassis Height: 240mm
10000ES 6 Overall Length: 1605mm
10000ES 7 Weight: 122.5kg
1000E 1 Model No: 1000E
1000E 2 Capacity: 1000kg
1000E 3 Minimum Saddle Height: 180mm
1000E 4 Maximum Saddle Height: 885mm
1000E 5 Chassis Width/Length: 650/1080mm
1000E 6 Saddle: Adjustable
1000E 7 Saddle Tilt - Forward: 25°
1000E 8 Saddle Tilt - Backward: 22°
1000E 9 Saddle Tilt - Side-to-Side: 12°
1000E 10 Weight: 130kg

Ideally I'm wanting to search for the Product Code (I.e 10000ES) and for the formula to return all the specifications in one cell with HTML tags. For example I would like this in cell F2:

<b>Model Number: </b>10000ES<br><br><b>Capacity: </b>10tonne<br><br> (and so on for all the specifications for that particular Product Code.

I hope someone will be able to help me out on this one.

Thanks
Luke