
In Excel,
Value of first row is "a", and the next subsequent rows are empty, those needs to be filled with the value same as the first row i.e "a" until it encounters other value. The moment it gets the value "d" the next rows after "d " should be "d" replacing the empty values and so on irrspective of number of rows below it.
For Eg: The input is,
and the Desired output should be,
Hi @Swatiba ,
Here is a sample flow logic. if required customize it as per your need.
Copy & Paste to flow designer
| Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''D:\\Fill Excel\\Sample Data.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance Excel.GetFirstFreeRowOnColumn Instance: ExcelInstance Column: $'''H''' FirstFreeRowOnColumn=> FirstFreeRowOnColumn LOOP LoopIndex FROM 2 TO FirstFreeRowOnColumn STEP 1 Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: $'''H''' StartRow: LoopIndex - 1 ReadAsText: False CellValue=> ExcelData1 Excel.ReadFromExcel.ReadCell Instance: ExcelInstance StartColumn: $'''H''' StartRow: LoopIndex ReadAsText: False CellValue=> ExcelData2 IF ExcelData2 = $'''%''%''' THEN Excel.WriteToExcel.WriteCell Instance: ExcelInstance Value: ExcelData1 Column: $'''H''' Row: LoopIndex END END |
If I have answered your question, please mark my post as Solved.
If you like my response, please give it a Thumbs Up.
Regards
Kaif