Manipulating data into a report

Hi all,

I'm trying to get my data manipulated into a certain way. So from this:

to 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.

Alteryx Example.yxmd

Reporting

Output

Parse

Accepted answers

Here is an approach that can solve the requirement. It maintains the data order also.

Hope this helps. Check and let me know.

Cheers and Happy Analyzing : )

Alteryx Example.yxmd

All comments

Here's one way of doing it:

reformat data.yxmd

Here is an approach that can solve the requirement. It maintains the data order also.

Hope this helps. Check and let me know.

Cheers and Happy Analyzing : )

Alteryx Example.yxmd

Thanks both! Both would work for me, marked the second one as solution purely because it maintains the data order too. thanks again.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703