Merged Cells

[suraj46nair]

Hi Team i have template with names and subnames.

I want header names to be merged with cells.

can you please help me developing the same.

i have attached sample excel file with expected output img.

please help in generating the same.

[davidskaife]

Hi @suraj46nair 

You can do this using the Reporting tools, there is an excellent series of blogs on how to do this starting here - https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746... 

[suraj46nair]

@davidskaife I did followed this article and tried to build based on provided steps. but it was bit confusing for me and i was not able to build the solution :(

[davidskaife]

@suraj46nair can you share what you had build so far and we can take a look?

[suraj46nair]

@davidskaife 

i used select tool after input tool and rename duplicate column with blank spaces.

and then i used table tool to try make them center align thats the workaround i used for timebeing.

I know its not best practice method to do.

PFA workflow.

[davidskaife · Accepted solution]

Hi @suraj46nair 

Here you go, following the guidance on this page ( https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787... ) i've built you this which gives the below output:

I've done no formatting or anything and on the Layout tool at the end I've had to make the config for Input_#3_Table specific width of 10% due to this being a single cell.

Also note on the Render tool its currently set to temporary excel.

Workflow attached!

[suraj46nair]

thnx david this really helped.