Book2.xlsx

Hi I need help in creating pivot table, which will contain text file (grant or deny)

example of data table (on source more then 7000 rows) is in attachment as well as desired look of new table.
anyone to help?