I have an excel spreadsheet with two colomns I needed. The data in those
columns is presented as follows:

Product Equipment
6OL 1702/1701
6OL/LHH 1716
LHH/6OL/SOL 1720
SOL 1701 To 1716

The product code is always 3 digits (but it can be number and letter) and
equipment code is always 4 digits (numbers). I have a database table the
Product list and another table with the Equipment list.

In the excell spreadsheet, the Product column can include one product or
several products through /. The same is for the Equipment column, in addition
it can be as 1701 To 1716.

How could I prepare this data for database usage using some formulars or
queris? Probably, it can be done in an additional excel spreadsheet first
extracting all possible combinations of products and equipment and grouping
it.

Finally, it should be like this:

Product Equipment
6OL 1702
6OL 1701
LHH 1716
LHH 1720
.....

Thanks