CODEWITHSUNDEEP
excelexcel-formula
Robert Jan Ki
Robert Jan Ki

Reputation: 81

Textjoin within a range every 3 columns

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.

example result

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

Upvotes: 1

Views: 162

Answers (1)

JvdV
JvdV

Reputation: 75930

As per confirmation by OP, one can use:

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

Upvotes: 2

Related Questions