Urgent Help....
 

Hi All,
I have 4 csv report file with the following file name as follows :-
Interspec_CH_EOD_Report.csv
CHPending.csv
Interspec_HD_EOD_Report.csv
HDPending.csv

my query is I want all HDPending.csv data to be copied in
Interspec_HD_EOD_Report.csv file at the end of the row of

Interspec_HD_EOD_Report.csv file deleting the heading row from HDPending.csv
like for CHPending.csv also to be copied to Interspec_CH_EOD_Report.csv file.
Then I want common data to be removed no data to be repeated.

TIA

Urgent Help....
 

Open all files in Excel...

Copy and paste as you want...

Sort the data
Select data
Choose Data-Filter-Advanced Filter
Choose Copy to another location
Click on Uniqe Records only
Specify where you want the result
Click Ok


"kiran" wrote:

Hi All,
I have 4 csv report file with the following file name as follows :-
Interspec_CH_EOD_Report.csv
CHPending.csv
Interspec_HD_EOD_Report.csv
HDPending.csv

my query is I want all HDPending.csv data to be copied in
Interspec_HD_EOD_Report.csv file at the end of the row of

Interspec_HD_EOD_Report.csv file deleting the heading row from HDPending.csv
like for CHPending.csv also to be copied to Interspec_CH_EOD_Report.csv file.
Then I want common data to be removed no data to be repeated.

TIA