I trying to build a pivot table using a column that has multiple values separated by a comma. For each register (line) this column could have different values in different quantities. Something like:

XXXXX YYYYY valueA, valueB, valueC
KKKKK ZZZZZ valueD
HHHHH TTTTT valueB, valueC

My question is: is there any way to have the pivot considering each value of the last column as a separated one? In other worlds, how can I transform the table above in something like this:

XXXXX YYYYY valueA
XXXXX YYYYY valueB
XXXXX YYYYY valueC
KKKKK ZZZZZ valueD
HHHHH TTTTT valueB
HHHHH TTTTT valueC

Thank you and best regards,
R. Inomata