Forum Discussion
TEXTJOIN, with a Value that is that of a cell which is at the intersection of a Column and Row
Hello, In the attached spreadsheet, I created the formulas in cells B27, B28, B29 rather clunkily. But they achieve what I am after: A delimited (by comma) text string with value of a Row 3 cell, ...
Use this:
=CONCATENATE(TEXT(INDEX($D$3:$R$3,MOD(ROW(B27)-ROW($B$27),15)+1),"0.0"),",",TEXT(INDEX($C$4:$C$22,QUOTIENT(ROW(B27)-ROW($B$27),15)+1),"0.0"),",",TEXT(INDEX($D$4:$R$22,QUOTIENT(ROW(B27)-ROW($B$27),15)+1,MOD(ROW(B27)-ROW($B$27),15)+1),"0.0"))
See the attached version.
- Thank You Hans. Well written.
Ultimately, it inspired me, and I went a much a simpler way.
Much appreciated, Alvin
