I have a list of numbers/information going down in the same column (eg.
A1:A10). On another tab, I would like to "fill" this information in but I
would like to go across columns on the same row (eg. A1:K1). I have tried to
use the "=Sheet!A1:K1" however the source data is going down, not across.

Example:
Sheet1:
45
58
22
65
44
69

Sheet2(I would like the data above to be 'filled' across, not down):
45 58 22 65 44 69

Can anyone help?