Here is my input (read range):
Now I want an output in a new sheet like this:
Basically in need all the names in one row and all the roll Numbers in another row
Number of rows and columns (in Input sheet) are dynamic and not fixed.
Thanks a lot