I am currently using this formula to retrieve and combine multiple cell data into one cell and make them comma separated
JOIN(",",TRANSPOSE(B3:B69))
But is it possible to do the same but only retrieve cell data in column B is the corresponding A column cell equals certain criteria (example = "yes")
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]yes[/TD]
[TD]john
[/TD]
[TD]john,paul,jake,dave[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]paul[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]no[/TD]
[TD]jake[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]no[/TD]
[TD]dave[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
(I have looked through the forum but can't find this specific question)
JOIN(",",TRANSPOSE(B3:B69))
But is it possible to do the same but only retrieve cell data in column B is the corresponding A column cell equals certain criteria (example = "yes")
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]yes[/TD]
[TD]john
[/TD]
[TD]john,paul,jake,dave[/TD]
[/TR]
[TR]
[TD]yes[/TD]
[TD]paul[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]no[/TD]
[TD]jake[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]no[/TD]
[TD]dave[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
(I have looked through the forum but can't find this specific question)