Excel report output with write to specific cell (stack two different tables together)

[a-x]

Is it possible to output to excel the table format below?

I need to output a different excel file for each portfolio.

The first cell changes depending on what the portfolio is (eg. Portfolio=Cards, Portfolio=Loans). The table below is for that specific portfolio. 

The excel filename also needs to have dynamic name (filename is read from a variable containing the date- I have the output data tool doing this). I asked a few Alteryx staff and got no responses about this. 

Portfolio = XXProductNm
Field1	Field2	Field3	Field9
Bob	S	1234 Street	Country
Barbara	T	1235 Street	Country

[DavidP · Accepted solution]

I would do that with 2 separate Output Data tools, one to write the portfolio name to cell A1 like this \your fullpathname\filename.xlsx|||Sheet1$A1:A1 - use option to skip field names for this.

The 2nd would write the data to cell A2 andbeyound like this \your fullpathname\filename.xlsx|||Sheet1$A2:B

obviously make sure that the filenames and filepaths are exactly the same for both.