column with multiple delimited IDs

[mompermj]

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!

[markcurry · Accepted solution]

You can use Text To Columns, and split your Group Codes field by the slash, and choose the Split to rows option

[benakesh · Accepted solution]

@mompermj ,

You can use Text to columns for  splitting  columns and creating rows for group codes.

[mompermj]

thanks again. i didn't realize that i never thanked you.