I have a client spreadsheet with client names in column A (starting in A2)
and a series of client information in each column B-!!. If the client
information is missing i have "pending" written in the cell. What i want to
do is make a type of report that will return column headers (ie column b is
company name) for each client where the value in the cell is equal to
"pending". For example if Row 3 Mr. X has pending in columns 5-10 and 21, i
want to return a list of column names to look some this like this

Mr. X Missing
column 5 name
column 6 name
column 7 name
column 8 name
etc....
I don't know how to write macros, i though maybe a pivot chart would work,
but i can't think of how to do it....thanks for any feedback.