I received an old attendance tracker spreadsheet, in which occurrences were entered in as calendar entries. On the left side is employee names, across the top are days 1-31, and in the intersections codes like T, for tardy, U, for unexcused absence etc. are entered. I have a years worth of these spreadsheets for 40 employees that I need to turn into a list of names and occurrences for processing. I am stumped on the easiest way to do this. Any suggestions?