0 - 2 of 2 tags for single row

Hello everyone
 
I would like some help to convert a single row into multiple rows
I have something like this
store | item | quantity
001 | A | 4
001,002 | B | 5
004,006,003 | C | 12
 
And i would like to do something like this
 
001 | A | 4
001 | B | 5
002 | B | 5

Say i have data like below

TEMP1

TEMP2

TEMP3

TEMP4

It need not be only four, it can be any number.

 

And i want the output in the following format

 

TEMP1TEMP2TEMP3TEMP4

 

 

Thanks in advance...