Reading in multiple rows and separating into individual columns

[mkafui]

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!!

[MarqueeCrew]

@mkafui ,

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

Cheers,

Mark

[mkafui]

@MarqueeCrew, 

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

Here you go.

Thanks!

[MarqueeCrew]

@mkafui ,

Based upon your jpg, here's a solution:

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

Cheers,

Mark

[MarqueeCrew · Accepted solution]

@mkafui ,

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

Cheers,

Mark

[mkafui]

Hi there Mark,

Your workflow works like a charm!! 

I made a few modifications to parse in some extra rows of data and the output looks solid.

Really appreciate your help. Thank you.

Max

[MarqueeCrew]

Max,

 I'm glad to be of service. Thanks for adding your question. 

cheers,

 mark