Excel output numbers stored as numbers in table with header

[I2ufu5]

I was wondering if alteryx is able to output table to excel looking like this:

Header1.1	Header1.2	Header1.3
STRING	STRING	STRING
Header2.1	Header2.2	Header2.3	Header2.4	Header2.5
STRING	NUMBER	STRING	STRING	STRING
STRING	NUMBER	STRING	STRING	STRING

Where values under Header2.2 are stored as numbers and excel recognizes them as numbers (currently they are strings cause whole column needs to be string type)

[HomesickSurfer]

Hi @I2ufu5 

You need to split your data into 2 tables then define the field type of the secoind table to number, union, layout, render...

Workflow attached.  Hope you like it and accept as solution.

[I2ufu5]

Unfortunately this doesn't solve my problem. Reporting tools create messy formatted table with all columns having a text header. I need something looking exactly like the table from first post when I open it in excel.

Header1.1	Header1.2	Header1.3	Unwanted header	Unwanted header
STRING	STRING	STRING
Header2.1	Header2.2	Header2.3	Header2.4	Header2.5
STRING	NUMBER	STRING	STRING	STRING
STRING	NUMBER	STRING	STRING	STRING

[HomesickSurfer]

As far as i know, you can't output fields without field names.

You may want to consider appending your data starting at Row3 to a template with the initial header and string data in Rows1-2.