Converting horizontal data to vertical data with multilple rows

I would be grateful for help please to reformat a table in which data for each named person is presented in one row with mutiple columns into a table in which each named person has multiple rows and one column of data. The solution to to this has eluded me so far.

The attached example shows before and after. Any help would be very much appreciated.