Making a list from a matrix... in numbers

Hi all,

I run into this problem quite a few times now when working with a matrix. I use matrix a lot as it is a good way to capture data. It is also quick and easy. However, there are times when I need to create a list from this matrix. So, below you will see my Matrix which shows in column A a list of standard hazards (one per row. the remaining columns show different machine types (e.g. Application Tower). The intersection uses H, M, or L, (High, Medium, Low) to signify the levels of risk in the case. Most of the matrices that I build either use 'Y' or 'X'.

So, from this matrix I want to extract a list as follows (for each machine type in turn)... The List table that I would like to produce is shown below.

Here, I want to list out the hazards and associated risk that relate to a specific 'machine type' (in this case, Application Tower). I would like to convert the entire matrix content as a long list.

I would be extremely grateful for any suggestions on how best to do this.

Thank you in advance.

Perry