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.
