Google Sheet Formula to remove Duplicates in multiple columns

Question

I've scoured the forums but can't find an answer. And this is the 2nd time I've had to write this!

I have a google workbook where "Sheet1" gets its data from a dump from Zappier. Column B is named "Service Title".

For some reason, this information is being 'collected' all in one cell (so instead of one "Service" being listed in B2, the entire list of like 30 services are all going there...

(actual example: 1. Inspect the Right Front Fender,2. Inspect the Right Front Door,3. Inspect the Right Rear Door,4. Inspect the Right Rear Quarter Panel,5. Inspect the Trunk and Rear,6. Inspect the Left Rear Quarter Panel,7. Inspect the Left Rear Door,8. Inspect the Left Front Door,9. Inspect the Right Front Fender,10. Inspect the Hood / Front,11. Inspect the Engine Compartment,12. Inspect the Vehicle's Roof,13. Inspect the Vehicle's Interior,14. Inspect the Vehicle's Tires & Wheels,Shampoo Carpet(s),1ST RINSE: Gentle Rinse,2ND DRY,1ST WASH: Paint is steam cleaned to remove microparticles of dirt and contaminants,2ND RINSE: Gentle Rinse,2ND WASH,3RD RINSE: Gentle Rinse,Spray Wax Finish,1ST DRY: This includes Vehicle being both wiped down and blown dry,INTERIOR: Interior vacuumed, Interior parts steam cleaned and sterilized,WHEELS: Wheels De-Ironing & Steam Cleaned to remove dust and dirt,TIRES: Tire Shine applied).

And it's doing the same for the next row and so on.

Pic of "Sheet1" where the data is 1st dumped:

Using Sheet2" and =IF(Sheet1!$B2>0,(TRANSPOSE(SPLIT(Sheet1!$B2,",")))," ") in cell A2, I've managed to separate each service from B2 out to its own row, but now I have nowhere to put the services from B3! And, while 99% in B3 are most likely duplicates, we can't be sure until we test them.

In light of that I used "Sheet2" Column C for B3, Column D for B4, etc.

Pic of "Sheet2" where the data is separated into rows but now duplicated in columns:

I'm sorry this is so confusing! But my head is spinning from watching/reading how-to's all day.

Thank you in advance. Any help would be GREATLY appreciated!

DG