I'm looking to transpose the data from table1, which is vertical to table 2 which is horizontal. Ultimately, special codes with be applied (outlined below) to present a summary of review and questions folks have. The initial report is very linear. Please see the attached workbook for examples.
Table 1 feeds table 2 with these values:
If a person's name is on this list they didn't review the ticket which equals "N"
If they have a comment, then the value is = "Q"
If their name is not there = "Yes"
Bookmarks