I'm a little stuck. I have a table with gene names as column headers and
patient samples as the row headers. In our lab testing, each patient sample
will have at least one (many times more) genes that have a numerical value
associated with it. For example, sample A987 may have a result in the table
under gene A, gene D and gene L. All other cells for which a patient does
not have a sepcific gene is blank. I need to find a function that can look
at the table in the row for sample A987 and tell me which genes the patient
has (i.e. the column headers of gene A, gene B, etc.). If it is possible to
have each gene listed as a value in one cell all in the same column, that
would be great. Thanks in advance for any help.