How do I copy the text?

Hello everyone,
I’m want to copy the previous line of text to put the blank line.
I have the following information. test.xlsx (9.6 KB)

Thanks.
Perawat

1 Like

Hello @Perawat,

You can go through this post

Cheers
@Perawat

1 Like

Hi @Perawat :wave:

You can achieve this using a for each loop. Kindly follow the below steps:

  1. Read the Input Excel and store the result in a DT.
  2. Use a For Each Row activity and iterate through the DT.
  3. Create a local variable, say “Temp” and store the value of row(“Bill No”) in it.
  4. Check if the variable returns an empty string using String.IsNullOrEmpty() function.
  5. If it does, assign the value of the “Temp” variable to the row(“Bill No”) inside the ‘then’ block.

Try this and let me know if you are still facing any issues.

Cheers!

1 Like

@monsieurrahul, Could you please write a workflow for me ?

1 Like

@Perawat
find some starter help here:
FillUp_BlockBlanks.xaml (8.7 KB)

3 Likes

@Perawat Here you go:

Main.xaml (9.1 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.