Split & Merge cells

[Sattysats]

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. 

[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,

M.

[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. 

[Sattysats]

Hi @mceleavey - Please find the dummy data snippet.

[mceleavey]

@Sattysats ,

we need to see the data. An image of some headers is of no use.

M.

[Sattysats]

Hi @mceleavey - My concern is with the header only. Say no data in it then entire ask is to create only what shown in the snippet.

[Gaurav_Dhama_]

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

[caltang · Accepted solution]

This is how you can do it: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/RE-How-to-Create-Merged-Cells-...

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