I would like to check whether Alteryx can be used to merge multiple Excel files with a predefined layout, similar to the attached example.
@pranpriya
If you opt to directly write to the template file, we use the "Preserve Formattting feature" in "Output Data" tool as below.
If you want to write to the copy of the template file, we can refer to this thread.