Similar Row entries to column in Excel

Dear

I want to arrange a data in perticular maner

SAM Class 5
SAM 3256
SAM ” Address ”
SAM ” Telephone No.”
RAM Class 5
RAM 3356
RAM ” Address ”
RAM Telephone No.”
and so on to

NAME RollNo Class ContactNo.
SAM 3256 Class 5 Telephone No
RAM 3356 Class 5 Telephone No