Read Multiple data from columns to one row

Help
#1

Hi Team,

This my scenario
image

I am trying to read the data from excel sheet using read range.

Robot should read the column values corresponding to the rows.

Once this reads all the columns corresponding to first row…It comes to the second data (2) to read SSS,DDD,FFF

I am using for loop to achieve this …Please suggest me

Thanks

#2

Hey, As I can understand from your problem you want to read each row from column1 first and after that read all the rows for column2. am I right?

#3

No I want to read row A2 → 1 and B2,B3.

Then It should read A4-> 2 followed by SSS,DDD,FFF.

Then it should read A7->7 followed by corresponding columns VVV,VVV,BBB,BBB.