Using the "Fill" function
hi Mike,
on sheet2, select the range a1:k1
use an array formula:
=transpose(sheet1!a1:a10)
enter with ctrl+shift+enter not just enter
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Mike" escreveu:
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?
|