Transposing formula

Hello,

I am new to excel and am struggling to find an appropriate formula to transpose data from the current format:


KEY DATA TITLE(A) 1
additional info 2
additional info 3
additional info 4
additional info 5
KEY DATA TITLE(B) 1
additional info 2
additional info 3
additional info 4
additional info 5
KEY DATA TITLE(C) 1
additional info 2
additional info 3
additional info 4
additional info 5

etc...

To the following:

KEY DATA TITLE(A) 1 2 3 4 5
additional info
additional info
additional info
additional info
KEY DATA TITLE(B) 1 2 3 4 5
additional info
additional info
additional info
additional info
KEY DATA TITLE(C) 1 2 3 4 5
additional info
additional info
additional info
additional info

Any advice on this matter would be hugely appreciated!!
Cheers!

Try look here or here or here

Aye, but its the gaps in the rows that are giving me grief, not the actual transposing. :noidea: