I have a flow that creates and excel file from Metadata.
It creates single Excel files.
I would like to be able to merge all single file content in to one Excel file as the end result, keeping the same header row and appending rows of content from the original files.
Creating a new file sounds like something a script would handle. Perhaps you should post a request in the scripting flow. You will need the scripting module installed, though.