Home > database >  Reverse order of TEXTJOIN range of cells in a row
Reverse order of TEXTJOIN range of cells in a row

Time:01-24

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.

A screenshot showing the results of the formula on an example data set.

Functions used:

  • enter image description here

  • Related