Textjoin every three columns

[andrew_milonavic]

Hey Everyone,

How do I textjoin every 3 columns?

data is on one sheet, results on another.

example below:

Data sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Dog[/TD]
[TD]cat [/TD]
[TD]Fish[/TD]
[TD]Car[/TD]
[TD]Truck[/TD]
[TD]Plane[/TD]
[/TR]
</tbody>[/TABLE]

Results sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Dog, Cat, Fish[/TD]
[TD]Car, Truck, Plane[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks

Andrew

 

[Jonmo1]

Try

=TEXTJOIN(", ",TRUE,OFFSET('Data Sheet'!$A$1:$C$1,0,(COLUMNS($A:A)-1)*3))

 

[andrew_milonavic]

Thanks Jonmo1!! Works perfectly.

Andrew

 

[Jonmo1]

You're welcome.