Split & Merge cells

Hi All,

I am looking to merger the cells as per the image attached. Can someone guide me to achieve this?

The Yellow ones are the normal columns i am getting from the data. I would like to split the column and add a name to it as highlighted in blue.

Merge.png

Preparation

Accepted answers

caltang

This is how you can do it: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/RE-How-to-Create-Merged-Cells-in-Reports-Part-2-Render-Output/td-p/996815

If you need help, please give us dummy data. Else, you have to follow the solution I sent you above.

All comments

Gaurav_Dhama_

Can you provide more details. Is this yellow output created by Alteryx and you want it to be like blue header with yellow merged cells?

mceleavey

Hi @Sattysats ,

We're going to need a lot more information than that.

Can you post some data, dummy data is fine, which is representative of your data and what it is you want to see?

Thanks,

Sattysats

Hi @Gaurav_Dhama_

The yellow one is pulled from an input file. The file has yellow headers with multiple rows below it. I just need the blue headers added to it. Attached a sample snippet.

Merge Columns.png

Sattysats

Hi @mceleavey - Please find the dummy data snippet.

Merge Columns.png

Gaurav_Dhama_

Can you separate, input data and output data and show? Right now, it is not clear still.

caltang

This is how you can do it: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/RE-How-to-Create-Merged-Cells-in-Reports-Part-2-Render-Output/td-p/996815

If you need help, please give us dummy data. Else, you have to follow the solution I sent you above.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703