Help request to concatenate

Hi friends,

I want to concatenate columns in column ‘G’ and ‘O’. In column ‘O’ I want to drop middle name but I’m not getting the correct output as require.

Any help will be highly appreciated.

Thanking you,