Excel Activities empty rows has to fill

Help Activities
, ,
1

Hi Team

I have a downloaded input file with some rows are not filled . for bot purpose i need those to to fill with data
Example : In the input file for 12110158704 Record ID from AU column to BA i have data for next 5 rows remaining columns also should fill with data.

Input fie:
PO_creation_WF.xlsx (13.5 KB)

Output file
PO_creation_WF.xlsx (14.3 KB)
l

Please help with solution

2

Hi @vinjam_likitha ,
I have solution for same topic
Use for each, fill blank row

regards,

3

Can you please elaborate

4

I have seen your file and have a lot of columns, some hybrid columns have data and need to be retained, this is confusing and seems like more variables need to be created, here is my example with 2 writes column, you can add additional variables with columns need change
fill blank row.xaml (31.8 KB)

5

I cannot open you xaml

6

BlankProcess.zip (31.8 KB)
try with zip file all of project

7

I think fpr each column we have to write the logic but it is very difficult.

I need 10 to 15 columns data

8

Yes I see, I think can use data table with range, sample Aindex-Hindex,…etc