Need assist in excel

Help Activities
, ,
1

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

image
image912×434 13.1 KB

Copy data from one excel to another excel with column. It works fine. Output: image
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:
image
image778×246 3.7 KB

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

2

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 :wink: