I have a spreadsheet which contains rows which have part number data in them
(in this case the spreadsheet is created from a Bill of Material report which
has the components' info in the rows).

This sheet has reference designator (locations of components on a circuit
board) column which contains a variable number of locations.

I can do a text to columns parse on the location column to get x number of
columns with each reference designator in a separate colum. How do I/ can I
repeat the part number in column A with a separate individual reference
designator?

I want to end up with something like:

Original: PN XYZ | locations x2,y2,z2

Desired result: PN XYZ | location X2
PN XYZ | location Y2
PN XYZ | location Z2

Excel is a wonderful tool, but I'm still relatively new to more
sophisticated features. Is this doable?

Thanks in advance,

Dave