Capture data of multiple cells (columns) in a row and put it in an array variable

[jogu]

Hi everyone, I would like to ask if there is a way on how to capture data in a multiple cells in a row in an excel spreadsheet and put it in a variable to be use for another purpose (like paste it in another excel spreadsheet in another workflow or sub-workflow).

Below is a sample scenario, the workflow will loop in column A (Served), look for the row with a "Yes" string then capture  the data in columns B, D & E in the same row, then in another worksheet search for the first blank row in the Item Id field and paste the data.

     

Thank you,

[Qiu]

@jogu 
Hope  this is what you you need.

[jogu]

Thanks @Qiu for your prompt reply. Can I put this in a loop so that all the users in another worksheet will be filled by the data from the other worksheet?