Combine cells to create HTML paragraph

[Flexi1]

I have a supplier spreadsheet with Headings and data, I need to find out how to combine selected headings and then data into one paragraph from multiple cells.

The data is product information across multiple cells & headings and I want to format it so that I can create a HTML product description using all the data.

The product page below shows an example

Hooded 2-Layer Softshell Jacket - Professional Waterproof Workwear

Professional 2-layer softshell jacket with hood, perfect for work and outdoor environments. Features waterproof, windproof design with full zip and multiple pockets.

www.flexi-print.co.uk

Below shows desired HTML with the combined cells

<p>Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.</p><h3>Features:</h3><ul><li>Full-length zip with storm flap and chin guard</li><li>Three-panelled hood with adjustable toggles</li><li>Two front zipped pockets</li><li>Elasticated cuffs</li><li>Raglan sleeves</li><li>Shaped to fit</li><li>Inner hem with adjustable toggles</li><li>Showerproof</li><li>Windproof</li><li>Two inside pockets</li></ul><p><strong>Fabric:</strong> Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.</p><p><strong>Weight:</strong> Outer and inner layer: 290gsm</p><p><strong>Care Instructions:</strong> Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.</p><p><strong>Size Guide:</strong> Regular fit. See size chart for detailed measurements.</p>

 

[6StringJazzer]

An example of your results is essential, but we can't give you a solution without seeing what this data looks like in your Excel sheet.

 

[Flexi1]

An example of your results is essential, but we can't give you a solution without seeing what this data looks like in your Excel sheet.

I'm trying to install XL2BB but I'm having difficulty at the moment to show an example.

 

[Flexi1]

An example of your results is essential, but we can't give you a solution without seeing what this data looks like in your Excel sheet.

SHOPIFY FULL DATA TEMPLATE.csv
	K	L							S			V	W
1	Specification	Retail Description							Washing Instructions			Fabric	Weight (GSM)
2	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
3	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
4	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
5	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
6	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
7	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
8	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
9	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
10	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
11	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
12	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
13	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm
SHOPIFY FULL DATA TEMPLATE

 

[Flexi1]

Does anyone have any ideas?

 

[6StringJazzer]

Many of your columns are blank, and it's just the same row repeated several times.

This is the best I can do. The sample Excel data does not have all the data that you showed in your initial example so I'm just guessing which data in Excel maps to which field in the HTML.

$scratch.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Specification	Retail Description							Washing Instructions			Fabric	Weight (GSM)	HTML
2	Reliable 2-layer bonded softshell jacket with hood. Full-length zip with storm flap and chin guard. Three-panelled hood with adjustable toggles. Two front zipped pockets. Elasticated cuffs. Raglan sleeves. Shaped to fit. Inner hem with adjustable toggles. Showerproof. Windproof. Two inside pockets. Easy re-label system. Product contains no branded neck label. Removable Kimble or looped garment tags. Inner seam label holds important product information on one label, with a second label containing brand information which can be cut away.	Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.							Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.			Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.	Outer and inner layer: 290gsm	<p>Maintain a smart and professional appearance in this hooded 2-layer softshell jacket – a style inspired by a classic. Suitable for a wide range of work and outdoor environments with its contemporary design and functional features, including a full-length zip with storm flap and chin guard, adding another layer of protection.</p><h3>Features:</h3><ul><li></li><li></li><li></li><li></li><li></li><li></li><li>Inner hem with adjustable toggles</li><li>Showerproof</li><li>Windproof</li><li>Two inside pockets</li></ul><p><strong>Fabric:</strong>Outer layer: 98% Polyester, 2% Elastane. Inner layer: 100% Polyester.</p><p><strong>Weight:</strong> Outer and inner layer: 290gsm</p><p><strong>Care Instructions:</strong>Machine wash 30°. Gentle setting. Do not bleach. Iron low. Do not tumble dry. Do not dry clean.</p><p><strong>Size Guide:</strong> Regular fit. See size chart for detailed measurements.</p>
Sheet10

Cell Formulas
Range	Formula
N2	N2	="<p>"&B2&"</p><h3>Features:</h3><ul><li>"&C2&"</li><li>"&D2&"</li><li>"&E2&"</li><li>"&F2&"</li><li>"&G2&"</li><li>"&H2&"</li><li>Inner hem with adjustable toggles</li><li>Showerproof</li><li>Windproof</li><li>Two inside pockets</li></ul><p><strong>Fabric:</strong>"&L2&"</p><p><strong>Weight:</strong> Outer and inner layer: 290gsm</p><p><strong>Care Instructions:</strong>"&I2&"</p><p><strong>Size Guide:</strong> Regular fit. See size chart for detailed measurements.</p>"