Merge column over other existing columns

[Polite123]

Hi Experts,

Need some help in merging data.

Input data:

A	B	C
0	1	2

Output data:(I want column D to be over other columns A,B and c in the merged form and should be centre aligned...the image below is incorrect...as D should not be only over A but also B and C...just like D getting merged over A B and C in Excel(Merge and Center))

D
A	B	C
0	1	2

Thanks in advance:)

Thanks in advance

[T_Willins]

Hi @Polite123,

To get a header row with Merge and Center you can use the reporting tools and output to a file.  The attached workflow outputs to a temporary Excel file, but it can be modified to output to a named Excel file.  Formatting of the table data can be done in the Table tool.

[grazitti_sapna]

Hi @Polite123 , alternate method.

Thanks.

[Polite123]

Thank you both of you for solutions:)

But how to export it into excel?While doing so I am getting some layout column which is incorrect.

[grazitti_sapna]

Hi @Polite123 , you can try this config.

Thanks.

[Polite123]

Thanks a ton:)

It worked and has solved 75 percent of problem.

Can something like below be achieved?

I have attached the file

[grazitti_sapna]

Hi @Polite123 , try this.

Thanks.

[Polite123]

@grazitti_sapna---You are magical:)Thanks for the optimized solution:)

It worked upto 95 %.But still the alignment is not getting matched as per my requirement.

I have attached the file for reference.Please help me with the alignment and border margin which I am unable to do so

[grazitti_sapna · Accepted solution]

Hi @Polite123 , I tried replicating the desired output hope this works for you. For Specific template we need to create a separate workflow.

Please refer to the workflow.

Thanks.

[Polite123]

Thanks @grazitti_sapna.

How can we add border to individual cell.I am not getting bottom line for each header in data shared.Could you please help?