This repository was archived by the owner on Mar 17, 2026. It is now read-only.
This repository was archived by the owner on Mar 17, 2026. It is now read-only.
some double quotes are removed from beautified result. #105
=""""&IF(J$2>1,"""""""","")&TEXTJOIN(""""",""""",FALSE,OFFSET(GalaxyLoad_MasterData!$A$1,$D7-1,J$3-1,J$2,1))&IF(J$2>1,"""""""","")&""""
Above formula results in below. some double quotes are removed i.e. ="""" is reduced to =""" in first part and double quotes are also removed throughout the "beautified" formula.
=""" &
IF(
J$2 > 1,
""""",
""
) &
TEXTJOIN(
""",""",
FALSE,
OFFSET(
GalaxyLoad_MasterData!$A$1,
$D7 - 1,
J$3 - 1,
J$2,
1
)
) &
IF(
J$2 > 1,
""""",
""
) & """