How to write a Horizontal value in excel into vertically along with starting from specific cell range?

In Excel1Traffic Headers.xlsx (10.1 KB)
In Sheet2 having a session value that is in vertically manner then i need to write a values in another Excel2 Marketing Performance copy.xlsx (12.4 KB)
In sheet1 i need to write a value from C4 to H4

Can any please help…

Thanks in advance

@keerthi_arumugam

Have you tried DT transpose? Check the below thread.