Flatten a Random Matrix

Hey I am trying to dynamically flatten the attached matrix to return two columns (A6:B17). The first being the associated letter, and the second being a combination of the numbers and columns. I think this can be down with a combination of lookups, tocol, and unqiue; but I can't quite get it to work. Thanks so much!