Multiple outputs with multi-row header on each

Question

Hi, I am trying to create multiple output files from a table based on the filepath, which is a column in the table. So for example, I'd want to split this into 3 files (it's actually a lot more than 3, but this is made up data):

Header 1Header 2Filepath Header132Filepath 123Filepath 1864Filepath 2522Filepath 34564Filepath 3

I then have a little table with a few rows and columns (like below) that I want to insert on top of EACH one of these files. So however many different filepaths there are in the above table, that's how many files there would be, and each one would have the same few rows on top, then the data from the table above below that. Any ideas?

This is    notrealdata

Thanks!

Felipe_Ribeir0 · Accepted Answer

@btuchyner , Here is a way of doing this:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.