Merge multiple excel files into sharepoint folder

Hello, I have 4 folders created with excel workbooks that follow the same column-level scheme. When I try to compile files using the binary option, a table is created that only contains data from Ec...