Blanks cells against date picking without duplication in row to column

Data:

Branch Invoice No Invoice Date Value Dispatch Date
BHOPAL 4903714620 01.04.2015 2873.96 05.04.2015
BHOPAL 4903715258 02.04.2015 1907.08 05.04.2015
BHOPAL 4903717196 04.04.2015 1907.08
BHOPAL 4903718178 06.04.2015 9017.08
BHOPAL 4903718298 06.04.2015 9017.09
BHOPAL 4903718299 06.04.2015 1907.08 10.04.2015
BHOPAL 4903720880 08.04.2015 9915.9 10.04.2015
BHOPAL 4903722128 09.04.2015 12789.86

Req Format

Branch Invoice Date

Bhopal: 04.04.2015 06.04.2015 09.04.2015

How do blanks cells against Invoice Date picking without duplication from row to column for corresponding to the Branch's

please help me. file and snap shot attached herewith.

Perhaps something like this, using array formula..


cheers

see if this works for u...I had done it applying filter

azumi Sir,

most of date return perfect against of branch,

but some of Branch date return error.

pl help me.file attached.

Ok fix it.........

azumi Sir,

thank you so much for your reply. now its working perfectly.

{=IFERROR(INDEX(Dispatch!$E$2:$E$65536,SMALL(IF(FREQUENCY(IF((Dispatch!$C$2:$C$65536=$E16)*(Dispatch!$G$2:$G$65536=""),MATCH("~"&Dispatch!$E$2:$E$65536&"",Dispatch!$E$2:$E$65536&"",0)),ROW(Dispatch!$E$2:$E$65536)-ROW(Dispatch!$E$2)+1),ROW(Dispatch!$E$2:$E$65536)-ROW(Dispatch!$E$2)+1),COLUMNS(Dispatch!$C$1:C12))),"")}

The above formula based on that i have apply sheet to sheet.But it takes very long time return the value (calculating processor time)

As requested to you if any other solution for this query.

Pl help me.

jayajaya_4 Sir,

Date are return duplication and some of date return wrongly against of Branch.

How do transpose formula against of branch and return the Date without duplication.