Merge column over other existing columns

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

Datasets

Accepted answers

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.

Merge-updated-GS.yxmd

All comments

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.

Add Header Row.png

Add Header Row.yxmd

Hi @Polite123 , alternate method.

Thanks.

Merge column over other existing columns-GS.yxmd

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.

Hi @Polite123 , you can try this config.

Thanks.

Thanks a ton:)

It worked and has solved 75 percent of problem.

Can something like below be achieved?

I have attached the file

Hi @Polite123 , try this.

Thanks.

@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

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.

Merge-updated-GS.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 387

Hollingsworth 335