I want to fill the row data in the database

Help Activities
, ,
1

image
image857×766 22 KB

Like the data table in the picture above
The value of a1 b1 is filled up to a10 b10
The value of a11 b11 is filled up to a19 b19
after keep going againg
Is there any activity?

Excel’s own function does not work because the function was pasted as a value after use.
Excel is attached.

TEST.xlsx (26.5 KB)

2

Could you please eloberate your requirement?

3

Hi @sssim4567 ,
You can use for loop,
assign value blank to code
if row not blank assign value to new code

regards,
LNV

4

like this

image
image1050×767 19.9 KB

Fill in the blanks, which is Excel’s own function, does not work by pasting it as a value

5

Please explain it in detail.
activity or expressions

6

Hi,

How about the following sample?

image
image1215×1133 36 KB

Sample20230821-3L.zip (26.7 KB)

Regards,

7

Hi @sssim4567 ,
My code
excel.xaml (29.7 KB)
my output
TEST.xlsx (26.5 KB)
you can test again
regards,
LNV

8

Thank you. It works. It does take some time
Thank you for solving this problem

9

Thank you for your reply, but it hasn’t been resolved. The results are the same.

10

Oh, I think it is not best solution, but I think it is too simple to understand,
The recent topics you’ve posted are related, I guess it’s a mature process.

regards,
LNV

11

Did you check result.xlsx? I think it’s same as your requirement.

image
image789×751 16.6 KB