How should i generate a list of names using input data (marked with green in image)
Please check Image for example.
Try using the following formula:
=TOCOL(B2&" "&B3&" "&TOCOL(B4:N4,1)&" "&TOROW(B5:N5,1))
Try using the following formula: