Perform a loop to read a specific value

[shehryarazhar]

Hi,

I am struggling to find a way to perform a loop to read a specific value. I am trying to perform a lookup against specific values in a column and create unique strings. For example, the data is organised as below. Each x is linked to the y immediately preceding it and therefore, I want to lookup the column 2 value against the y and assign it to the x values under it. Appreciate suggestions to help solve this issue.

column 1 column 2

y              123

x              

x

x

y               345

x

x

x

x

x

[DanielG]

@shehryarazhar - check out the multirow tool

[Felipe_Ribeir0 · Accepted solution]

Another option, also using the multirow:

[shehryarazhar]

Thanks a lot. It got me on the right track. I used a modified version of your proposal to fit my data.