Using the "Fill" function

M

Mike

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?
 
P

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
 
M

Marcelo

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:
 
Top