Creating new rows from a single row of data

Hi all

I am new to this forum and while I am very successful achieving what I need by googling, trial and error, and Kutools, this one has be beat.

I have rows of data that begin with a unique identifier, a student number, and each row contains a set of 3 columns with student provided information on educational modules they are taking of which there are up to 8 modules in the one row. However, I will need to address the issue with each module for each student and sort them by module.

I am trying to transpose each of these 3 cells onto a new row with the student identifier so each module can be dealt with row by row for each student. I would really appreciate a signpost or two to the best approach this and have exhausted everything I can think of.

I man manage the opposite just fine.

Any assistance is appreciated.

Kind regards

Gregori Meakin

Thanks for this and sorry for the delay - it put me on the road to PowerQuery and I am amazed and what I am achieving.