Append tables from the same workbook but make modifications before expending the tables.

Actually the Excel files in the folder are the binary files. I think that if you look at the sample file itself, you've expanded the binary file into a table. Instead, do not expand the sample file (remove the step that makes the sample file a table), and then go back to your Transform Query. Now the steps that you add to the Transform file will be applied to all the files, and you'll see a column of binaries before you invoke the transform function. 

--Nate