Sorting data and create new sheet help!

Copper Contributor



I'm trying to figure out if there is a way to sort out big data by a value in a new sheet.


For example, this is what a part of my data looks like after exporting and there are hundreds of data like this in one sheet:

Screenshot 2022-12-21 at 10.56.05 AM.png


- Person 1's data is from 1-47 (I treat 1-47 as one data),

- I would like to sort out the data by each Person's name.

- There are hundreds of data like this and Person 1's data not only appeared once, there could be multiple data under the same Person's name (one teacher teaching multiple courses) throughout the data, not in order.

- My objective is to sort out the data (1-47 for Person 1 for example) by Person's name and automatically put them in a new sheet (e.g.  if Person 1 has taught 5 courses and each course data is placed randomly, not in order - I would like to collect all 5-course data for this Person 1 and have them automatically placed in a new sheet under Person 1's name.) I hope this makes sense. This job cannot be done manually because it takes so much time to complete.


Does anyone know if there is a way to do this in Excel? Thank you so much in advance!

1 Reply
I think it's possible with a formula. You'd need access to Lambda.