As your request to IT dept, make pivot table that you need below. Now TUI worked has been complete. Please find attachment.
In sheet “GAP Ratings raw date” within Excel file, we used these raw date to make 2 pivot table is GAP Rating and QI Rating (On the right hand side of the table).
Please check the accuracy that match you need or not. And Do not hesitate to contact us again if you require any further.