How to read the data column wise

I need to read the data column wise.

Ex: i need to get firstname one by one in messagebox
input.xlsx (7.9 KB)

Hi,

There are some ways to achieve it. One of them, how about using transpose as the following sample?

Sample
Sample20240509-7.zip (9.6 KB)

if i want first name only means. what i need to do?

Hi

If you need only first name, the following will work

Sample
Sample20240509-7 (2).zip (9.5 KB)