Excel data copying from column names multiple times in same excel

Hi,
I have 2 excel file(file1 and file 2) need to consolidated into single file.
Both the files have same column names multiple time.
Please find the image files and output need as below.
Thanks