transpose loop with "empty cell" condition

Hi,

As I'm a total beginner when it comes to macros, I would really need help with looping a macro throughout my spreadsheet, conditioned by empty cells. I'm probably not that good at explaining, so below I've attached the example. My only comment is that the ORDER in which the cells are being transposed is extremely important, as u can also notice from the file.

Thanks in advance, your help will be highly appreciated !
Ana