copy values in every row

[DaVerve]

Hi,

i have a Excel File look like this:

  name2
   dog
  (empty)
  (empty)
    cat
  (empty)
  (empty)
   bird
  (empty)
  (empty)

I like to copy the value dog in each row under name2 untill the value cat arrives, when cat arrives the same should happen and in every row cat should be copied an so on. I do not reallly know how to solve this problem. I hope someone can help me.

thanks in advance

[gutlez]

Try the repeat option in the Excel input step.

[DaVerve]

Hi,

where can i find this option?
In the Excel Input i didn't found anything like this.

Thx

[MattCasters]

In the Fields tab there is a Repeat column.

[DaVerve]

Thank you very much!!