Data Sorting/Grouping Function

Dear Community,

Good evening.

Here I am struggling again trying to choose one of the many ways excel offers of solving our data issues! Hence the ambiguous title. Please advice if i should rename thread.

Attached is a small sample of Data. It is missing 10,000 rows and 26 Columns to give you an idea of its size.

I am looking for the most efficient way of groping this data.

I would like to group the data by NVQ type and students undertaking the NQV including the accompanying certificates they are doing.

NB* each student has a unique Learner Ref Number COLUMN A

Sheet 2 shows a small sample of my desired ouput.

I do hope that I have been clear and that this thread conforms with the forum rules given the Title.

Thanks in anticipation
Darren Chapman