Convert unstructured data from rows to sorted columns

[jhosmer002]

Hi, I am looking to create a workflow that creates a table of organized data into columns from unstructured data. It is a list of individuals and various information about them all in one row. As you scroll down, you will see that there is a second individual with their data all in one row. 

How to I move this data from one row into the various columns using Alteryx? 

The file of the data is attached for reference, and happy to chat more. Thank you!

[CharlieS]

I assumed that fields beginning with "Profile result -" indicated that a new record was starting. Check out the example solution attached to this post and let me know that works for you. 

 

[kat · Accepted solution]

Hi @jhosmer002

Here's something to get you started. 

Cheers

Kat

[jhosmer002]

Thanks so much! There was another solution that worked better, but I will be saving this for the future. 

[jhosmer002]

Thank you so much! This is exactly what I was looking for. I really appreciate your time and assistance :) 

[jhosmer002]

@kat If I wanted to obtain more assistance with this workflow, is there a way to receive 1:1 help in the community? Thank you! 

[kat]

@jhosmer002, you can always keep asking and I'm sure someone will keep getting back to you :)

if not, you can reach out to Alteryx support (support@alteryx.com)