Excel - Query

Help Studio
#1

Hello people!!

How can i loop through only even rows of a column. If there is any way please let me know!!

Thanks in advance !!

#2

@Rakesh_Sampath …could you please explain your query with example?

#3

Hi @prasath17
I have a excel column named Phone number, I need to loop through that column to get the data but only the even row’s data i.e, 2nd row’s 4th row’s etc.

Thanks

#4

Have you tried using RowIndex?

#5

@Rakesh_Sampath - There may be better way…this is one i just thought…

image
image1346×629 23.7 KB

My input:

image

Output:

image

You can see, it is reading only 2, 4 6, 8 and 10…

2 Likes