Get the last row values filled in current sheet

Question

I need to fetch the last row values of the form response tab sheet to the current sheet and then Transposed and displayed columnwise excluding the first timestamp column

I tried but this get unexpected results

=TRANSPOSE(INDIRECT("'Form Resposes1'!" & COUNT('Form Resposes1'!A:A)+1 & ":" & COUNT('Form Resposes1'!A:A)+1))

The response tab sheet looks like:

The expected result from the formula is:

Answer 1

This should work if your sheet is named "Form Responses 1":

=TRANSPOSE(SORTN('Form Responses 1'!B2:H,1,0,'Form Responses 1'!A2:A,0))

References:

• SORTN
• TRANSPOSE