Multiple Row Header Table

[allancubos]

I need help in making a multiple row header table here in Alteryx. The output I want is something that can be downloaded into an excel file.

Have tried it using Summary but I am not getting what I want. Can someone help me please?

Attached is the Alteryx file along with my expected output file.

Thank you.

[Emil_Kos]

Hi @allancubos,

I have prepared a template that looks like this to make it work:

This the workflow:

By choosing some options we could keep the data in the correct format:

[allancubos]

Thanks Emil.

This is the output I got from your attachment.

But this is far from what I exactly need below. Anything else I have to do?

[Emil_Kos]

Hi @allancubos,

In order to make it work you need to create a template file with proper columns.

It is the easiest way to achieve it.

And the output is appending below those lines. 

[allancubos]

Hi Emil,

How can I do a template file with proper columns? 

How can I make that output table using the below raw file?

Can you make a workflow that when I run, it would give the result that I want? Have tried Summarize & Crosstab but can't see the result I want.

Raw File:

[Emil_Kos]

Hi,

The template is attached.

You will need to remember to output the data using the range. 

So keeping this part is important:

$A2:J15

C:\Users\kosemi\Downloads\Expected Excel Output - Copy.xlsx|||Sheet1$A2:J15

[allancubos]

Thank you Emil. Will check the workflow you attached. Can't access it now because my Alteryx version is outdated. Would have to update it first,