Copy paste transposed text with a formula to go in certain columns?

Hi all,   I currently have a data set that looks like this:         I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", the...