Hello, it’s a repetitive task and I’m trying to implement it with RPA logic because it’s a lot, but I can’t think of a way, so I’m asking for help.
The first rule.
Content in column B moves to column A
Invoice value in column E moves up one space in column F
The First rule is shown in the figure.
The second rule
Content under BCD column moves up one space
The second rule is shown in the figure.
Third rule
Copy the contents from columns A to F
Stuck until date in next column B
The Third rule is shown in the figure.
The results are as follows.
The rule will continue until the bottom blank comes out.
I want to make a logic that repeats the rule, is there a way? If you help me, you’ll save me!
I am attaching the file.
19년 미국 병합본_수정.xlsx (658.0 KB)
plz help
Anil_G
Yoichi
Akash_Javalekar1
jast1631
k.sakaguchi0804
singh_sumit
Nisha_K21
shaik.muktharvalli1
postwick
naoko0623