Read Multiple data from columns to one row

Hi Team,

This my scenario

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


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?

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.