I am a PE teacher and my pupils need to choose 3 sporting activities to be assessed in as part of their final grade. They have a wide selection of activities. I want to be able to create a pivot table to gather the information across 3 columns and identify all duplicate activities into 1 column, so that it creates a list of pupil who have chosen each activity.