replace 2nd column blanks with values in same column if blank
Where ,SOMELOGB and ,SOMELOGC replaces each /r carriage return if 2nd column is blank. The replace only happens if 2nd column is blank though and should replace up to the non blank row.
TEST,SOMELOG TESA,SOMELOGA TESB TESC TESD,SOMELOGB TESE TESF TESG,SOMELOGC
TEST,SOMELOG TESA,SOMELOGA TESB,SOMELOGB TESC,SOMELOGB TESD,SOMELOGB TESE,SOMELOGC TESF,SOMELOGC TESG,SOMELOGC