splitting column by row identifiers to create multiple columns

[D_Jackson171]

Hey guys, first post here as thus far I've been able to find answers throughout the excellent community here. I am stumped on something that looks seemingly easy but the transpose and text to columns tools aren't working for this particular scenario. Essentially what I'm needing to do is create multiple columns for each intuitive code a customer has on their order. If they have only 1 item then the other columns should be blank. 

how the data looks:

how I need it to look:

The goal is to identify customers who are ordering the same items at regular intervals. I'm wanting to split the columns so I can create an identifier and use that to count how many times that order happens.

Thank you for any assistance.

[atcodedog05]

Hi @D_Jackson171 

Can you share this data as excel file or paste the data in the post not in image format.

We will be happy to help🙂

[D_Jackson171]

@atcodedog05 

I've attached the file. Thank you

[atcodedog05 · Accepted solution]

Hi @D_Jackson171 

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @D_Jackson171 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂