Formula I am using in Google Sheets:
=TEXTJOIN(CHAR(10)&CHAR(10),true,C2:2)
I want to reverse the order those cells are joined so that it is always the furthest right cell first.
Please see image below for example of what I am trying to achieve.
Functions used: