Reporting tool - how to create excel with grouped columns/rows

Question

Hello,

I need to output my data into excel where some of the columns are grouped, based on the column names.

My output should look like the attached file - columns E, F and G are grouped.

Thanks!

Eyal

agentzerow · Accepted Answer

If you set up named ranges in Excel, you can use the output tool to output to Excel and you would input the sheet name as the name of the range.

So:

Range1 - AtoD

Range2 - H

Use a Block Until Done, have it write to the first range then write to the second range.