Lookup the time from a row data

[vmjamshad]

Happy New Year to everybody,
I am trying to make a time-sheet format from a row attendance data. Row data will look like as below:[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]ID #[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Time[/TD]
[TD="align: center"]Type[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]1/1/2017[/TD]
[TD]07:00 AM[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]1/1/2017[/TD]
[TD]05:00 PM[/TD]
[TD]Out[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]2/1/2017[/TD]
[TD]08:00 AM[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]2/1/2017[/TD]
[TD]01:00 PM[/TD]
[TD]Out[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]3/1/2017[/TD]
[TD]10:00 PM[/TD]
[TD]In[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]4/1/2017[/TD]
[TD]08:00 AM[/TD]
[TD]Out[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]4/1/2017[/TD]
[TD]08:00 PM[/TD]
[TD]IN[/TD]
[/TR]
[TR]
[TD]100[/TD]
[TD]5/1/2017[/TD]
[TD]07:00 AM[/TD]
[TD]Out[/TD]
[/TR]
</tbody>[/TABLE]
From this data, i am trying to create a time-sheet format like below
[TABLE="class: grid, width: 250, align: center"]
<tbody>[TR]
[TD="align: center"]ID[/TD]
[TD="align: center"]1/1/2017[/TD]
[TD="align: center"]1/1/2017[/TD]
[TD="align: center"]2/1/2017[/TD]
[TD="align: center"]2/1/217[/TD]
[TD="align: center"]3/1/2017[/TD]
[TD="align: center"]3/1/2017[/TD]
[TD="align: center"]4/1/2017[/TD]
[TD="align: center"]4/1/2017[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"]IN[/TD]
[TD="align: center"]Out[/TD]
[TD="align: center"]In[/TD]
[TD="align: center"]Out[/TD]
[TD="align: center"]In[/TD]
[TD="align: center"]Out[/TD]
[TD="align: center"]In[/TD]
[TD="align: center"]Out[/TD]
[/TR]
[TR]
[TD="align: center"]100[/TD]
[TD="align: center"]07:00 AM[/TD]
[TD="align: center"]05:00 PM[/TD]
[TD="align: center"]08:00 AM[/TD]
[TD]01:00 PM[/TD]
[TD]10:00 PM[/TD]
[TD]08:00 AM[/TD]
[TD]08:00 PM[/TD]
[TD]07:00 AM[/TD]
[/TR]
</tbody>[/TABLE]

I used vlookup function. But having trouble in Date 3/1/2017, coz here a shift is starting from one day and ending on another day. Can anybody assist on this.

Thanks,

Jamshad