Hi can you help me how to arrange my data here:
Color | Code |
red | 1 |
blue | 2 |
yellow | 3 |
Primary | |
MAIN | |
orange | 7 |
green | 11 |
purple | 13 |
Secondary | |
OPTIONAL |
Expected Output:
Color | Code | Type | Category |
red | 1 | Primary | MAIN |
blue | 2 | Primary | MAIN |
yellow | 3 | Primary | MAIN |
orange | 7 | Secondary | OPTIONAL |
green | 11 | Secondary | OPTIONAL |
purple | 13 | Secondary | OPTIONAL |
Can you help me with this one pls?
Solved! Go to Solution.
hey @dunkindonut7777
I believe i've built what you need.
Theres bound to be someone to reply with a less tool solution - however this is dynamic so with more rows/conditions should work fine.
I've attached the workflow, hopefully this helps!
Cheers,
TheOC