Transponse help excel

Can I speed up this process, not a problem for a couple of people, but if there is 150+ any help is welcome
As you can see in the pictures to get a result on the sheet 2 had to:

1. copy from sheet 1 paste special into new sheet (marked Transpose option)
2. select all cell with data and make degrees to 0
3. double center cells, modify cell to bold, font size etc...
4.repeat all for second person etc etc..

Is there any VBA or Macro to have this prosses automatically as I write data from one sheet to get a result on the sheet 2

https://www.flickr.com/photos/131020575@N05/shares/Di79Y8

Thank you.