Here is a possible solution for you. I just applied it to Dates Jan 5 to Jan 11. I changed the dates in the date rows to match the dates in the log and for the data for each date there are 4 rows that appear to be merged but are only formatted to appear that way.
The following formula is entered in B7 and copied down and across (Array Formula - Ctrl + Shift + Enter)
Formula:
=IFERROR(INDEX(Log!$B$2:$B$200,SMALL(IF(Log!$A$2:$A$200=B$6,ROW(Log!$A$2:$A$200)-MIN(ROW(Log!$A$2:$A$200))+1),ROWS($1:1)))&", "&INDEX(Log!$C$2:$C$200,SMALL(IF(Log!$A$2:$A$200=B$6,ROW(Log!$A$2:$A$200)-MIN(ROW(Log!$A$2:$A$200))+1),ROWS($1:1))),"")
Bookmarks