Merge 7 Excel fields into one cell, and convert content to HTML

IN PROGRESS
Bids
19
Avg Bid (USD)
$54
Project Budget (USD)
$30 - $250

Project Description:
This project is to merge 7 separate text fields in an excel table into an list (text field formatted in HTML) stored in new field. If any of the fields are blank, the formula should ignore and move to the next so there are no gaps in the output.

The Sample fields are
COMPANY_NAME | BUSINESS TYPE | LABOR | COMPANY_SIZE | PROJECT SIZE | COMPANY PRIM SIC | COMPANY SEC SIC

Merged list should look like (stored in one cell):
COMPANY NAME (ACME Installers)
* LICENSE (750631)
* LABOR (Non-Union)
* BUSINESS TYPE (Corporation)
* COMPANY_SIZE (5-10 Employees)
* PROJECT SIZE (<$100,000)
* COMPANY PRIMARY SIC (Flooring Installers and Retailers)
* COMPANY SECONDARY SIC (Carpet Installers)

When I apply your formula and conversion to HTML to my data I should get this output:

ACME Installers was added to the Company.com directory in 2013. The please confirm the following details when you contact them.
Please note: Installers can claim and update this record by clicking here.
* Company is State Licensed: 1234567
* This business is a Non-Union, Sole Proprietorship
* 5-10 Employees
* We usually take on projects: <$100,000
* Flooring Installers and Retailers, Carpet Installers

I will provide the destination where I am looking to upload this content (profile content on out site) so you can ensure that your html or css will work...

Looking to hire Monday morning for completion within 1 day. $30-$40 is my budget.

Skills required:
CSS, Data Processing, Excel, HTML, Website Design
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 54
in 2 days
$ 54
in 1 days
Hire best4best
$ 40
in 1 days
$ 43
in 1 days
$ 35
in 1 days
Hire rengrish
$ 40
in 1 days
$ 40
in 0 days
Hire Baxter2008
$ 30
in 1 days
$ 194
in 3 days
Hire sswijaya
$ 55
in 3 days