Link multiple things into a single table

Hi guys, I am new to programming in Excel

I am looking to take a matrices of data (see attachment) and display all corresponding data into a single cell

I,e, if there are multiple '1's in a populated table it would display all that they represent in another cell

I would like to do this for each column in the matrix. I don't think I've explained myself very clearly so if I need to give more details please just ask.

Attachments may give some help.