Help with VBA if bullet is found then create new cell with information below

[Musa15]

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: windowtext; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl63 { color: white; font-size: 10pt; font-family: Arial; vertical-align: top; border: 0.5pt solid darkgray; background: cornflowerblue none repeat scroll 0% 0%; white-space: normal; }.xl64 { color: white; font-size: 9pt; font-family: Arial; text-align: center; vertical-align: top; border: 0.5pt solid darkgray; background: cornflowerblue none repeat scroll 0% 0%; white-space: normal; }.xl65 { color: black; font-size: 10pt; font-family: Arial; vertical-align: top; border: 0.5pt solid darkgray; white-space: normal; }.xl66 { color: black; font-size: 9pt; font-weight: 700; font-family: Arial; text-align: right; vertical-align: top; border: 0.5pt solid darkgray; white-space: normal; }.xl67 { color: black; font-size: 9pt; font-family: Arial; text-align: left; vertical-align: top; border: 0.5pt solid darkgray; white-space: normal; }.xl68 { color: black; font-size: 9pt; font-family: Arial; text-align: right; vertical-align: top; border: 0.5pt solid darkgray; white-space: normal; }.xl69 { vertical-align: top; border-width: 0.5pt medium; border-style: solid none; border-color: darkgray -moz-use-text-color; white-space: normal; }.xl70 { vertical-align: top; border-width: 0.5pt 0.5pt 0.5pt medium; border-style: solid solid solid none; border-color: darkgray darkgray darkgray -moz-use-text-color; white-space: normal; }.xl71 { color: black; font-size: 9pt; font-weight: 700; font-family: Arial; text-align: left; vertical-align: top; border: 0.5pt solid darkgray; white-space: normal; }.xl72 { color: black; font-size: 9pt; font-family: Arial; vertical-align: top; border: 0.5pt solid darkgray; white-space: normal; }</style>

Carrier	CPT	Serv Date	60 Days	90 Days	120 Days	150 Days	Over 180	Total
Aetna P.O. BOX 981106 El Paso, TX 79998			0.00	0.00	0.00	0.00	-705.43	-705.43
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	45385	######	0.00	0.00	0.00	0.00	-705.43	-705.43
AETNA/MAGNACARE/NAP PO BOX 981107 MEDICAL CLAIMS DEPT EL PASO, TX 79998 (800) 345-5463			0.00	0.00	0.00	0.00	191.29	191.29
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	99204	######	0.00	0.00	0.00	0.00	191.29	191.29
Amalgamated Life PO Box 5435 White Plains, NY 10602 (212) 539-5000			0.00	39.26	0.00	0.00	0.00	39.26
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	99204	######	0.00	31.06	0.00	0.00	0.00	31.06
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	99212	######	0.00	8.20	0.00	0.00	0.00	8.20
BS AUTO PO BOX 80 BUFFALO, NY 14240 (716) 887-9201			0.00	13.67	0.00	28.61	20.31	62.59
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	99214	######	0.00	0.00	0.00	0.00	20.31	20.31
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	43239	######	0.00	0.00	0.00	28.61	0.00	28.61
• DOE, JOHN V (9275) DOB: #### Policy: ##### Grp: #####	99213	######	0.00	13.67	0.00	0.00	0.00	13.67

<tbody>
</tbody>

I think using VBA is the best way to approach this problem. I have a report that is generated (above) but need the data to be displayed a bit differently. Basically I need the insurance carrier (in bold) to be in column A row 1 and for all patient within that insurance (in bullet) to be listed next to the insurance name so Column B row 1.

Any help or suggestions on how to think through this would be helpful.

Thanks,