Help with Suitable formula to fetch data from one continuous table to another table arranged in columns

[prnambiar]

Dear Friends,

I have a data table (its a long table some abstract given here), I have to fetch the Data given in the "DISP ST" Column in another table (To be solved table) against the Car+Shift on that particular date which is entered in a series of Columns

Appreciate your valuable advise to solve the problem

Thanks
Pranil

DATA TABLE <tbody> </tbody>
CAR+SHIFT <tbody> </tbody>	Shift Date <tbody> </tbody>	DISP ST <tbody> </tbody>
1026 M <tbody> </tbody>	01/03/2017 <tbody> </tbody>	D <tbody> </tbody>
1029 M <tbody> </tbody>	01/03/2017 <tbody> </tbody>	D <tbody> </tbody>
1029 E <tbody> </tbody>	01/03/2017 <tbody> </tbody>	ND <tbody> </tbody>
1026 E <tbody> </tbody>	01/03/2017 <tbody> </tbody>	D <tbody> </tbody>
1029 M <tbody> </tbody>	02/03/2017 <tbody> </tbody>	D <tbody> </tbody>
1026 M <tbody> </tbody>	02/03/2017 <tbody> </tbody>	ND <tbody> </tbody>
1029 E <tbody> </tbody>	02/03/2017 <tbody> </tbody>	D <tbody> </tbody>
1026 M <tbody> </tbody>	03/03/2017 <tbody> </tbody>	ST <tbody> </tbody> <tbody> </tbody>
1029 M <tbody> </tbody>	03/03/2017 <tbody> </tbody>	D <tbody> </tbody>
1029 E <tbody> </tbody>	03/03/2017 <tbody> </tbody>	D <tbody> </tbody>

<tbody>
</tbody>

TO BE SOLVED <tbody> </tbody>
	Disp St Against DISPATCH DATES <tbody> </tbody>
CAR+SHIFT <tbody> </tbody>	01/03/2017 <tbody> </tbody>	02/03/2017 <tbody> </tbody>	03/03/2017 <tbody> </tbody>	Grand Total <tbody> </tbody>
1026 E <tbody> </tbody>	?	?	?
1026 M <tbody> </tbody>
1029 E <tbody> </tbody>
1029 M <tbody> </tbody>

<tbody>
</tbody>