Automate Data

Help Activities
, ,
1

i
Sample.xlsx (10.4 KB)
am currently working with an Excel file and need assistance with automating a specific task. Here are the details:

  1. Identify Row 6 in the Excel sheet.
  2. Copy the contents of this row dynamically (based on the data in Row 6).
  3. Paste the copied row six times below Row 6.
2

Hi @T_Y_Raju

check out the xaml
testforforum.zip (14.1 KB)
Take 6 rows from mainDT to ResultDT
Add 6th Data row 6 times using a loop
Add the remaining rows to ResultdT

Hope this helps!