I'm not sure if this is being made harder than it is. So, I'll give a simple solution and some guidance if it is actually harder than I think.
The easiest method when creating multiple outputs is to create another field with the sheet name and use the output tool with the option down the bottom to replace sheet name with that field. If it's totally separate files, then the column needs to be the filename and still use that option.
Now, looking again, I'm guessing that table is actually a template that is used to decide the columns in your data (that's not published).
In this case, you would want to transpose that table and remove nulls, that will give you a list of the columns needed for each type and use that to filter your data (probably transpose the data first for ease). Then assign a new column name to the data using a multi-row such as 1,2,3... (or if you want the other columns but just null() then don't reassign a name. Then crosstab that back and use the output as above.
