How to combine multiple files into 1

[johny9887]

Hi,

Currently, I have batch macro along with a workflow where I am attempting to combine 2 files into 1. I have an issue where each file has a beginning section like seen in a picture below that I am trying to get rid of. However, the rows in which the actual data starts differ between the 2 files. 

Is there a way to:

A) Get rid of the begging rows so only the actual data remains 

B) Combine the files together into 1 with only the actual data?

Thank you

[binuacs]

@johny9887 One way of doing this

[grazitti_sapna]

@johny9887 , Here is another way of doing this. You can achieve your desired output without using macro. Please accept my solution if it was helpful.