In this formula, I tried using TRIM but apparently it doesn't acknowledge CHAR(10), but only redundant spaces. If I don't have the referenced filled out, it will still enter a line break. How do I go about eliminating CHAR(10) if the cell before it is empty?

=TRIM(CONCAT('1'!A47,CHAR(10),'1'!B54,CHAR(10),'1'!B56,CHAR(10),'1'!B57,CHAR(10),'1'!B58,CHAR(10),'1'!B59,CHAR(10),'1'!B60,CHAR(10),'1'!B61,CHAR(10),'1'!B62,CHAR(10),'1'!B63,CHAR(10),'1'!B64,CHAR(10),'1'!B65,CHAR(10),'1'!B66,CHAR(10),'1'!B67,CHAR(10),'1'!B68,CHAR(10),'1'!B69))