Add multiple headers and merge the columns and rows

[sachin1987]

Hi All,

I was able to get the required data and finally struggling with the Formatting of the headers. It will be very helpful if someone can help achieve the desired output. I have attached the excel, in which their are 2 scenarios. It has Input and output tab which shows the what I need. For easy understanding I have added border to understand the Merge part.

Thanks in Advance!

[binuacs]

@sachin1987 below are the post by @atcodedog05 , these posts will give you an idea of how to merge cells in report

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

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

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

[sachin1987]

@binuacs Thanks for you quick response.

I had gone through the similar post and I was able to achieve some of the Merge cells. But I am still struggling with Output tab Cell A7,8, Cell D7,8, Cell G7,8 and in Output2 Cell A16,17, Row 15, and Cell J16,17.

[atcodedog05]

Hi @sachin1987 

Can you share your workflow with what you were able to achieve? We can take a look at it and suggest to you what to do.