Transpose rows into columns help needed

Question

I am trying to transpose multiple rows into columns. However what I'm having to do is an overly complicated formula to get what I need. Otherwise it's transforming column A, then Column B, then Column C and etc. I need it to transpose the entire row, then go to the next row and transpose that one.

This formula is working for me:

=TRANSPOSE({AL3:AV3,AL4:AV4,AL5:AV5,AL6:AV6,AL7:AV7,AL8:AV8,AL9:AV9,AL10:AV10})

However there could be hundreds of rows on my sheet. Is there a more simple formula for this?

Answer 1

try this formula:

=FLATTEN(AL3:AV)