I have 2 columns, one with a product, the other with a ";" delimited string associated to that product in an Access 2016 table. I need to break that string up into multiple rows and into a new table. For instance Product = 1234 and Location = abd;DEF;ghij;kLmNo into
1234 abd
1234 DEF
1234 ghij
1234 kLmNo
How?
1234 abd
1234 DEF
1234 ghij
1234 kLmNo
How?