Transpose based on helper column VBA

Hello,

I am trying to move data from column B into rows. In Column A, I have the corresponding Title to which the data in column B belongs to. However, I have over 10,000 lines. Is there any way to do this using VBA?

I have attached a spreadsheet as an example of what I am trying to accomplish.

Many thanks in advance and any advice is much appreciated.

Thanks!