Formatting Table for Export - Groupings as Headers

Question

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:

CountySpecialtyCityZipNameAddressADAMSGeneral DentistHANOVER17331First Dental Office123 MAIN STADAMSGeneral DentistHANOVER17331John Doe DDS123 MAIN STADAMSGeneral DentistHANOVER17331David Johnson123 MAIN STADAMSGeneral DentistHANOVER17331Rhonda Walker123 MAIN STADAMSGeneral DentistGETTYSBURG17325Jane Smith4600 YARD RDADAMSGeneral DentistGETTYSBURG17325Steve James DDS4600 YARD RDADAMSGeneral DentistGETTYSBURG17325Rachel Stevenson DMD4600 YARD RDADAMSGeneral Dentist

GETTYSBURG17325Adam Matthews DDS4600 YARD RDADAMSGeneral DentistGETTYSBURG17325John Moyer4600 YARD RDADAMSGeneral DentistGETTYSBURG17325Toby Carter DMD4600 YARD RDADAMSPediatricLITTLESTOWN17340Bill Smith340 LOMBARD STADAMSGeneral DentistLITTLESTOWN17340Alexis Zelis340 LOMBARD STADAMSEndodontistGETTYSBURG17325Megan Turns DMD353 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 CountyGETTYSBURG - 17325General Dentist  Adam Matthews DDS4600 YARD RDJane Smith4600 YARD RDJohn Moyer4600 YARD RDRachel Stevenson DMD4600 YARD RDSteve James DDS4600 YARD RDToby Carter DMD4600 YARD RD  EndodontistMegan Turns DMD353 MAIN ST    HANOVER - 17331General Dentist  David Johnson123 MAIN STFirst Dental Office123 MAIN STJohn Doe DDS123 MAIN STRhonda Walker123 MAIN ST  LITTLESTOWN - 17340General Dentist  Alexis Zelis340 LOMBARD ST  Pediatric  Bill Smith340 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 Answer

Can you do something with this?