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

test.xlsx

Workflow

Reporting

Accepted answers

binu_acs

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

Add_Header_1107.yxmd

All comments

binu_acs

@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/974692

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 @binu_acs

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

binu_acs

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

Add_Header_1107.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703