Format Output to Excel

[maxse]

Hi everyone,

I have a question regarding the exceloutput in alteryx. Is it possible to make this (like the excel function connect and center cells): 

Thanks and kind regards,

[Felipe_Ribeir0]

Hi @maxse 

One way of doing this, just format the color, alignments, etc as you wish

Workflow:

Excel Output:

The approach to merge cells came from here (atcodedog05): https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746...

The approach to align the text inside each cell vertically came from here (BenMoss): https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Set-text-in-report-export-to-be-middle...

[Felipe_Ribeir0]

Hi @maxse 

It worked?

[HomesickSurfer]

Hi @maxse 

Simply use the Summary Tool, grouping by No, Material and Package, then concatenate IDs with \n, resulting in grouped items with IDs as newlines.