Merging cells

Question

Hi colleagues - I am really hoping someone could help with a problem I am facing.

I dont know how to merge cells in here

I will show as Merge1 , Merge 2 and so on

In general how does it look like: I have two merged headers and data

Now problem is to create first merged cells

I have attached sample and my output with alteryx workflow, also added as a comment the data I am using.

Report.xls

sample.png

my output.png

New Workflow6.yxmd

binu_acs · Answer

@Karlygash_M There is a great article from @atcodedog05 about how to merge cells and output to excel

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

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

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

KrishnaChithrathil · Answer

@Karlygash_M

I'd suggest you to provide us some random data. not the actual one. It'll take much time to understand your complete scenario.

Karlygash_M · Answer

Data from the workflow

mapping.yxdb

data.yxdb