Hi designer community, I'm totally new to Alteryx but can already see how to leverage it to solve many problems, I just haven't quite figured it out yet. I I have an excel file that has data in multiple rows as below: The desired output is something like this: I have tried to use a Regex parse but the results were far from desired. Any help will be greatly appreciated. Thanks!! Sample.xlsx

Reading in multiple rows and separating into individual columns

Hi designer community,

I'm totally new to Alteryx but can already see how to leverage it to solve many problems, I just haven't quite figured it out yet. I

I have an excel file that has data in multiple rows as below:

Screen Shot 2020-01-10 at 11.47.52 PM.png

The desired output is something like this:

Screen Shot 2020-01-10 at 11.21.00 PM.png

I have tried to use a Regex parse but the results were far from desired. Any help will be greatly appreciated.

Thanks!!

Datasets

Regex

I made a minor modification after seeing your data (and fixing my name bug). This version looks workable:

Cheers,

Mark

Glad to have you here and part of the community. Please post a BEFORE xlsx of sample data.

Cheers,

Mark

Apologies, I failed to attach the file on my first post.

Here you go.

Thanks!

Based upon your jpg, here's a solution:

I broke the challenge down to elements that I could simply handle.

Cheers,

Mark