I want merge two cell and place the date value

[Sshasnk]

I have two columns date1 and date2 I have to put it on top of the headers, Align center and merge them like below

Input:

Fund	amount	purchase	return	buy	sell	Date1	Date2
A	123	456	489	785	123	31/12/2022	31/12/2021
B	456	500	800	400	456	31/12/2022	31/12/2021
C	489	564	87	450	23	31/12/2022	31/12/2021
Total	1068	1520	1376	1635	145	31/12/2022	31/12/2021

	31/12/2022		31/12/2021
Fund	amount	purchase	return	buy	sell
A	123	456	489	785	123
B	456	500	800	400	456
C	489	564	87	450	23
Total	1068	1520	1376	1635	145

[Felipe_Ribeir0]

Hi @Sshasnk 

I am not sure if i understood if you need any formatting, but to achieve a excel file that looks like your sample output, here it is

[PanPP]

Hi @Sshasnk 

I have uploaded a sample WF that merges the cells.

Hope this helps. If it does, please like the post and mark it as a solution.

[Sshasnk]

@Felipe_Ribeir0  I also want to merge cells B1+C1 which will have a value 31/12/2022 and E1+F1 will have a value 31/12/2021

For some reason I am not able post merged cell in my question because alteryx community is not taking it

[Felipe_Ribeir0]

Hi @Sshasnk 

One way of doing this, using this post made by @atcodedog05 as reference: https://community.alteryx.com/t5/Engine-Works/How-to-Create-Merged-Cells-in-Reports-Part-2/ba-p/9787...

You can change the aligment, text/column colors, etc inside of each table tool if you like

[Felipe_Ribeir0]

Hi @Sshasnk 

It worked?