Column Merge

[Sarath27]

Hi All,

I am trying to merge columns similar to excel.

Pls find the attachment for your reference both screenshot & excel file and kindly help me achieving this.

[caltang]

Like so:

[Sarath27]

Thanks much. I need to have a blank column after every grand total. i.e after 2023_07_31_Grand_Total there should be a blank column where next date should start.

[caltang]

You can add a column by using the Formula tool and title it as "Blank". Then use a Select tool to put some space between them.

If you have multiple, then you can add a row in te cross-tab/transpose section I did. 

Try it out and let me know. If you're stuck, I'll show you how. The clues above should teach you.

[Sarath27]

I am kind of confused of where I should add formula tool, pls assist me on this.

[caltang]

Try this. One of many ways.