Challenge #49: Reformatting Transactional Data

[RS452]

Good one..

[Joe_Lipski]

🙂

[NISCHITHA-98]

Solution

[WasimS]

Spoiler

Spoiler

[jjrbondoc]

Spoiler

[MariusNikiforovas]

Spoiler

[rrozanski002]

Done

[KodyKlein]

My tutor showed me how to do this a week ago. I waited a week and attempted to recreate the workflow without looking back at any notes. It took me a minute, but I finally got it! 

[davidhe]

Could be a macro? 

Spoiler

[KodyKlein]

Thanks so much for the feedback! I'm as green as it gets, so I really appreciate it. I downloaded your file and looked through your workflow. I like it a lot! It seems very elegant to separate the dataset into separate datasets for each product and then use a union tool to join them. I feel like the workflow I was taught is a bit visually simpler, but I think yours is more interesting, and really I like that you didn't have to use the formula tool to create new columns.