Formatting Table for Export - Groupings as Headers

[davidlittle]

I have a standardized report that I'm trying to replicate in Alteryx.  I have data grouped at a few different levels, but I'm struggling to turn the grouped data into a formatted report.  Here is the layout of the data as it is pulled in:

County	Specialty	City	Zip	Name	Address
ADAMS	General Dentist	HANOVER	17331	First Dental Office	123 MAIN ST
ADAMS	General Dentist	HANOVER	17331	John Doe DDS	123 MAIN ST
ADAMS	General Dentist	HANOVER	17331	David Johnson	123 MAIN ST
ADAMS	General Dentist	HANOVER	17331	Rhonda Walker	123 MAIN ST
ADAMS	General Dentist	GETTYSBURG	17325	Jane Smith	4600 YARD RD
ADAMS	General Dentist	GETTYSBURG	17325	Steve James DDS	4600 YARD RD
ADAMS	General Dentist	GETTYSBURG	17325	Rachel Stevenson DMD	4600 YARD RD
ADAMS	General Dentist	GETTYSBURG	17325	Adam Matthews DDS	4600 YARD RD
ADAMS	General Dentist	GETTYSBURG	17325	John Moyer	4600 YARD RD
ADAMS	General Dentist	GETTYSBURG	17325	Toby Carter DMD	4600 YARD RD
ADAMS	Pediatric	LITTLESTOWN	17340	Bill Smith	340 LOMBARD ST
ADAMS	General Dentist	LITTLESTOWN	17340	Alexis Zelis	340 LOMBARD ST
ADAMS	Endodontist	GETTYSBURG	17325	Megan Turns DMD	353 MAIN ST

From here, what I need to do is create a report that shows each individual County, City/Zip Code, and Provider Specialty, and then each Name/Address combination that falls under that grouping.  Here is an example:

ADAMS County
GETTYSBURG - 17325
General Dentist
Adam Matthews DDS	4600 YARD RD
Jane Smith	4600 YARD RD
John Moyer	4600 YARD RD
Rachel Stevenson DMD	4600 YARD RD
Steve James DDS	4600 YARD RD
Toby Carter DMD	4600 YARD RD
Endodontist
Megan Turns DMD	353 MAIN ST
HANOVER - 17331
General Dentist
David Johnson	123 MAIN ST
First Dental Office	123 MAIN ST
John Doe DDS	123 MAIN ST
Rhonda Walker	123 MAIN ST
LITTLESTOWN - 17340
General Dentist
Alexis Zelis	340 LOMBARD ST
Pediatric
Bill Smith	340 LOMBARD ST

There are some other formatting things, but those are easy.  Where I'm struggling is how to turn my groupings (County, City, Zip, and Specialty) into individual headers.  Thanks

[DavidP · Accepted solution]

Can you do something with this?