How to Map each value with other Values

[Vinod]

Hi all

Source Table:

REG NO	VALUE
A1	20171103-E0023-0 20171110-E0023-0
B1	20161125-E0034-0 20171130-30022-0
C1	20170717-C0036-0 20180226-E0052-0
D1	20160510-E0049-0 20160519-C0043-0 20160527-E0056-0
E1	20170330-E0059-0 20170824-A0018-0 20170922-30011-0 20171025-E0039-0

Above I have created one table and in that tables i want to Map the REG NO with each value of the VALUE column. Means  I want output like below mentioned table.        

REG  NO	VALUE
A1	20171103-E0023-0
A1	20171110-E0023-0
B1	20161125-E0034-0
B1	20171130-30022-0
C1	20160510-E0049-0
C1	20160519-C0043-0
C1	20160527-E0056-0
D1	20160510-E0049-0
D1	20160519-C0043-0
D1	20160527-E0056-0
E1	20170330-E0059-0
E1	20170824-A0018-0
E1	20170922-30011-0
E1	20171025-E0039-0

Please anyone reply     

Regards,

Vinod              

[tamilarasu]

Vinod - Have a look at the attached files. I have loaded the excel file (which you have sent to me ) and not able to find any duplicates.

[Vinod]

Ok. Once again i will check and let you know.

[Vinod]

Thank You Sir.