How to add header by merging several cells

[Paddi]

How to add header by merging several cells

Hi,

I'm currently working on the issue about adding a header for my excel sheet using Alteryx, certain cells should be merged (A1 to B3),  can anyone help me with it ? Thank you so much.

Need to convert sheet 1 to sheet 2 by Alteryx. The test excel has been attached.

Excel sheet 1

Excel sheet 2

[binuacs]

@Paddi The below post by @atcodedog05 will be helpful for your use case

https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-1/ba-p/9746...

[ShankerV]

Hi @Paddi 

If I understand your requirement correctly, 

You will have the inputs in sheet 1 and the output with header needs to be saved in the same input file but in Sheet 2.

1. Here is the solution to you

Step 1: Add the input tool and input the file.

Step 2: Add Block Until Done tool from Developer tab, this will enable to overwrite on the same input file.

If this tool is not used, it will not allow to save the output on the same file.

Step 3: Add the Output tool, select the Sheet 2 as to save the output.

This will resolve your problem.

Hope my solution helps to resolve your issue.

Many thanks

Shanker V

[ShankerV]

And for your second requirement to merge the cells, you can refer the response from my friend @binuacs 

Let me know if you need any more assistance in this.

[binuacs · Accepted solution]

@Paddi One way of adding the header using the Report Text Tool

[Paddi]

Thanks Binuacs, it solved most of my problem.

[Paddi]

Thanks Shanker,  I'm actually not facing the block issue in Alteryx, but thank you for your kind advice anyway.