How to duplicate every row and adjust content in an Excel document

[jonjo67 (Trung Sơn Nguyễn)]

Hi guys, I’m new to UIPath Studio (and VB.net) and was wondering if you guys can help me out with this issue that I have. I need to duplicate each row of an excel spreadsheet (except for the headers), and then adjust some information in the duplicated row. The duplicated row will be placed right beneath the original row.
Here is the input. I will upload the output example in the comments

Thank you all for the help !

[jonjo67 (Trung Sơn Nguyễn)]

Here is the output that I want

[TimK (Tim Kok)]

If you are not amending the original rows, I would personally read the excel file into a data table, make your amendments in the datatable to the relevant fields and then use append range to add the new rows underneath.

[arun_vignesh]

Happy assiting you @jonjo67,

I have created a macro for you. Please find attached the macro macro.txt (674 Bytes)
.
Please run the macro4 in that excel and confrim if that meets your requirement.

Automtion make lifes easy

Thanks,
Arun Vignesh S

[jonjo67 (Trung Sơn Nguyễn)]

Thank you for the advice TimK, however I would prefer to do this with macro on excel.

[jonjo67 (Trung Sơn Nguyễn)]

Hi @arun_vignesh,

Thank you for creating the macro for my file. I tested it on my excel file and it worked perfectly!

Automation do make life ALOT easier.

Thank you, good sir.

[arun_vignesh]

Could you please mark this as a solution and like my solution as well.

[TimK (Tim Kok)]

No problem, just this is uipath forum and not a vba forum which is why I gave that suggestion. But any automation is good automation.