This is my dataset, geocoded sports centres. The "1"s indicate that that particular sports centre has that particular facility.

I want my sheet to be able to display (in concantenated words) which facilities each centre has. As you can see, I was halfway typing it out manually, but I thought: "Surely there must be a better way"