Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Ok. Once again i will check and let you know.
Thank You Sir.