in the calculation event of Formcalc. put the logic. It worked for me. ( Note : - FieldName is name of subform field) and your logic should be placed at subform.if (Not(HasValue($.FieldName.rawValue))) then
$.presence = "hidden"
endif
Select Allow multiple lines, so the field will not overlap, instead it will chop and remaining will display in next line of same row (in other terms, Wrap in Excel).