Im trying to join data every 3 columns within a range and summen this in a result cell Within every 3 columns lays the datasequense like WEIGHT 300 mm and so on.

I know i have to have the textjoin function yet i don't know how to approach to do this in a range and split the data every 3 columns

CodePudding user response：

As per confirmation by OP, one can use:

=BYROW(A1:F2,LAMBDA(a,TEXTJOIN(" ",,TAKE(a,,3),"-",DROP(a,,3))))