Arranging output on final Excel file

[Brad1]

I'm running a Workflow that is that identifies Stores and what group they are in.  Is there a way, after each group moves to Excel to add the Header Line again followed by a space and then the next group and repeat and repeat?  Thanks in advance for any ideas / help.

Example:

GROUP	CHAIN	NABP	STORE_NAME	ADDRESS	CITY	ST	ZIP	Phone()
A1	1	0590554	ABC Store	100 Main St		CA	91604	(818)506-1111
A1	5	3148461	Some Random Store	200 Someplace St		NJ	07114	(862)276-2222
A1	7	4444725	Store Name Something	3163 S CHURCH ST		TN	37127	(615)225-3333
GROUP	CHAIN	NABP	PHARMACY_NAME	ADDRESS	CITY	ST	ZIP	Phone()
B4	12	0590554	STUDIO PHARMACY	5 South St		CA	91604	(818)506-5555
B4	8	3148461	709 ACE PHARMACY	10 Another St		NJ	07114	(862)276-2222
B4	6	4444725	LIFEPOINT PHARMACY	15 Maple St		TN	37127	(615)225-1111

[estherb47 · Accepted solution]

Hi!

Yes, with the Table and Render tools, it's easy.

In the table tool, you would set a grouping level at the top, and you'd choose "Group" in your example below. This creates separate tables, complete with headings, for each group level.

Then you'd add a Render tool. In that tool, configure the report to add whitespace between groups. Here's a snapshot of the render tool