Multiple outputs with multi-row header on each

[btuchyner]

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 1	Header 2	Filepath Header
1	32	Filepath 1
2	3	Filepath 1
8	64	Filepath 2
5	22	Filepath 3
45	64	Filepath 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
not	real	data

Thanks!

[Felipe_Ribeir0 · Accepted solution]

@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.

[btuchyner]

Yes, that should work, thanks so much!