Expand and See Topics Using an array formula which is a combination of Textjoin and If function​ Working of array formula​ Using UDF (User Defined Function) named textJoinIf_1​ Using advance UDF named textJoinIf_2 ​ TextJoinIf for horizontal table​ In the below image you can see left table and right table. In the right table I ... Read more