I'm trying to get my data manipulated into a certain way. So from this:
Basically it's taking the location field and using it as a title for the rest of the data. I intend to output this as a PDF or XLS file so i can format the title, but not sure whether to change the data first, and then use reporting tools, or solely use the reporting tools to achieve this.
Either way i'm struggling to achieve the desired results.
My example workflow is attached. Any help appreciated.