Using the "Fill" function

[Guest]

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?

 

[Pete_UK]

Highlight the numbers and click <copy>, then move the cursor to the
first cell in Sheet2 (where you want the 45 to be) and Edit | Paste
Special | Transpose (check) then OK and <Esc>.

Hope this helps.

Pete

 

[Guest]

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: