Use the transpose function. (Assuming the sheet with horizontal data is called Sheet1.)
=TRANSOPOSE(Sheet1!B4:E4)