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

How about

Please Login or Register  to view this content.

Another variant

Please Login or Register  to view this content.

That is Working for me thank you

Now i just have to go break it down and learn it

Bedankt en goede nacht!

Gareth

Graag gedaan, van hetzelfde