How should i generate a list dynamically using input?

27 Views Asked by At

How should i generate a list of names using input data (marked with green in image)

Please check Image for example.

enter image description here

1

There are 1 best solutions below

2
Mayukh Bhattacharya On BEST ANSWER

Try using the following formula:

enter image description here


=TOCOL(B2&" "&B3&" "&TOCOL(B4:N4,1)&" "&TOROW(B5:N5,1))