i have a data set that i received that contains some customer grouping information where a single customer has multiple IDs rolling up to it, but they're in a single row:
CUSTOMER | GROUP CODES| DATA....
12342 | AAA/BBB/CCC
12341 | DDD
13563| EEE/FFF
Is there any way to somehow 'tidy' up the group codes column and create multiple rows?
for example:
AAA | 12342
BBB | 12342
CCC| 12342
DDD|12341
in reality i'm trying to create a distinct mapping for group code to the overarching customer, but the number of group codes per customer can be variable.
thanks in advance!
Solved! Go to Solution.
thanks again. i didn't realize that i never thanked you.