SQL SERVER - 通过匹配行和列来创建表并放入Y或N.

I currently have a table with all the data, using this data i want to create another table which could be used for auditing purpose (similar layout like pivot table) I currently have a table with all the data, usi