how to write a transpose formula

[GVN KUMAR]

sir
could you please how to write a transpose formula
previous using ctr+alt+v+e using ok

but so many time updated data so required a transpose formula its automatic updated sir

so could you please write a transpose formula

sample file attached sir

 

[AVK]

Select data "B2" to "F2" press ctrl "C" (for copy)
Go to "B5" & right click > paste special > right mark on "Transpose" > press "ok"

 

[PaulF]

Select cells: B5:B9 set your formula to: =TRANSPOSE($B$2:$F$2) and press Ctrl-Shift+Enter

 

[GraH - Guido]

Or in B4 and down=INDEX($2:$2,,ROWS($A$1:A1))
or in B5 =OFFSET($A$2,,ROWS($A$1:A1),,)

 

[GVN KUMAR]

grah guido sir very much thank you sir two type is excellent working sir
paulf sir it working but all row is same value
avk sir its my old formula same

thank you sir