I have an excel spreadsheet with 950 patients each of which can have up to have procedures on one date. Some of them have had more than one admission. The column headings for example are Patient ID, Procedure Date, Procedure 1, Procedure 2, Procedure 3 etc. up to procedure 8. I need to count the average procedures for each admission. What is the best way to set this out on a pivot table please?