Need help to extract data to multiple excel sheets by Group and Header in each sheet

Question

Dear all,

Please help me to achieve the desired format as attached.

1. I can extract data to multiple excel sheets by Group, however, I cannot insert the Header in each sheet by using Header and Layout. I tried every option but Alteryx create another sheet for the header instead of merging with each sheet of each assignee.

2. Furthermore the output to the Jan to Mar fields are as string while I want to have each as number format.

Please help. Thank you.

output - desired format.xlsx

ask for help.yxzp

atcodedog05 · Accepted Answer

Hi @smile_dt06

Here is a way to do it.

Output:

Workflow:

The trick is to create the texts above data table as separate tables for each group. When tables are placed one above other and outputted they are come one above in excel making it looks a single table (make sure shown headings is disabled). This also solves problem of data types where numbers will be numbers instead of getting converted to string.

Take a look. Let me know if you have any questions.

Hope this helps 🙂