Need assist in excel

[Jesmine (Jesmine Trejo)]

Hi Guys, @Palaniyappan @Pradeep_Shiv
Hope everybody is doing fine! I need a assist.

Copy data from one excel to another excel with column. It works fine. Output:
But i want to copy two column with data and it will paste “SL NO” for B column and “Issuing Bank” column F and in between all columns name will be copy but not row values. Like srcShoot:

Note: Name 1, name 2 and so on its have row values but i need for this only column name.

Please some one help me.

Thank you

[Hiba_B (Hiba Beldi)]

Hi @Jesmine !
I would suggest you to use Merge datatable, with Ignore as MissingSchemaAction.
Here is an example to understand the line:Merge_excel_DT.xaml (7.7 KB)
Beware: you can’t run the WF unless you add the first read range you’re showing us in your screen