Spliting rows with variable values

Question

Hello everyone,
once again I am stuck and need your help. This is probably related to RegEX with which I am very beginner.
Namely, I have the following table. It contains:
-product names (alphabet - except for one example which has M18 in its name)
-punctuation
-product numbers (always 10 alpha-numeric digits)
-quantity
My task is to have product names and product numbers on separate rows. All punctuation and information about quantity should be removed. (marked in red).

This is the original table:

This is what the table should look like:

I am asking for your help.

Test.xlsx

Luk88kk · Answer

Awesome!

I would never have come to that.

Thank you very much.

Qiu · Answer

@Luk88kk 
We do need a big dataset to be more accurate.
based on current data, I havve only worked out the Field2.
For field 1, I am afraid we need an iterave macro to do it. Give me a bit of time.

0127-Luk88kk.yxmd

Thableaus · Answer

Hi @Luk88kk

Honestly there are too many variations to consider in a REGEX. Is there a better pattern for product name (specifically) other than just having letters and a possible "M18"?

If you could provide more patterns the expression can be more consistent to your use case. REGEX is all about finding patterns and standards.

Cheers,