;WITH MyData (ID, strcol) AS (
        SELECT 1, '"BUNGALOW 101,RIDGEWAY DR","POINT FORTIN",,,"TT","868-389-9769",,"ZPXB303191",1'),
    NewData (ID, ItemNumber, strcol) AS (
        SELECT ID, ItemNumber
            ,strcol=CASE WHEN CHARINDEX(',', Item) > 1 THEN REPLACE(Item, ',', ';') ELSE Item END
        FROM MyData
        CROSS APPLY PatternSplitCM(strcol, '["]'))
SELECT ID, (
    SELECT strcol + ''
    FROM NewData b
    WHERE a.ID = b.ID
    ORDER BY ItemNumber
    FOR XML PATH(''))
FROM NewData a
GROUP BY ID