Multiple dates in same table ... need an new fields with unique date

[Anonymous]

Hi all,

        I'm attaching my data in excel file. we have 2 date fields from same table ..and i want a unique date field mapping those two date field so that i can use that new field as a dimension in one of my chart

Any suggestion would helps

Sri1

[its_anandrjs]

It is the final output by the load statements

ID	Date
P0532920	6/19/2013
E0532923	6/19/2013
P0533214	6/21/2013
P0533872	6/28/2013
E0533928	6/28/2013
E0545094	10/18/2013
D0549935	12/5/2013

Let me know about this.

[anbu1984]

Do you need extra rows only for duplicate rows?