Transpose bank statement from vertical to horizontal and fill missing gaps

So here is a function I have not worked with before, but I believe I want to use a transpose function

So I have a set of transactions, listed vertically, in a date then value format, with some dates missed out, some dates multiple values
- to match an old format, I want to list transactions for each day horizontally, and show blank days as well

I am able to do this one 'batch' at a time manually with transpose command, selecting all the lines for a single date, and pasting special to another cell - that's easy peasy

But how do I make it work on a big batch of numbers, and is transpose the best command to use?

I have set up an example, showing two sheets, one as the 'input' and a second sheet as the 'output format'

I can run this on a single sheet if you want, not bothered if we mess up the data or overwrite it - its getting pasted into a blank sheet then copied out anyways
In the output, i would like to include all dates, including gaps with no transactions

total rows so far is around 1000

Any help appreciated

Gareth