So I know that empty cells are the worst for generating pivot tables however I have a huge csv that is generated like this:

and this is the pivot table that gets generated from it.

I am wondering if there is a way to have the dates "merged" by ID as an ID will always have the same Date?

Desired Output:

Here is a link to my test google sheet:

Output:

Let me know if you have any issues or questions.

References:

• 

  ---

  or if you want totals:

  =ARRAYFORMULA({QUERY({A:C, VLOOKUP(ROW(D:D), IF(D:D<>"", {ROW(D:D), D:D}), 2)}, 
   "select Col1,sum(Col2) where Col2>0 group by Col1 pivot Col4"), 
   QUERY({A:B}, "select sum(Col2) where Col2>0 group by Col1 label sum(Col2)'Grand Total'"); 
   {"Grand Total", TRANSPOSE(MMULT(TRANSPOSE(QUERY(QUERY({A:C, 
   VLOOKUP(ROW(D:D), IF(D:D<>"", {ROW(D:D), D:D}), 2)}, 
   "select sum(Col2) where Col2>0 group by Col1 pivot Col4"), "offset 1", )*1),
   SEQUENCE(COUNTUNIQUE(A2:A), 1, 1,  ))), SUM(B:B)}})
  

  

  ---

  or if you really love pivot table design:

  

  demo sheet