moving range of data listed up/down to across

[howardh]

Hi,

I have a range of data entered in range A:1 thru A:26

I would like to move the data so it appears on one long line going
across instead , say line 1 columns A - Z.

I am using excel version 97.

Thanks for your help.

 

[Freemini]

If you copy A1:A26 using paste special, check the box Transpose and this
will copy the data across the sheet.

Note you should copy this to B1 and then delete column A if this is no
longer required

Hope this is what you were after

Mike

 

[Peo Sjoblom]

Select A1:A26, copy it, select B1, do edit>paste special, select transpose,
click OK.
Select column A, do edit>delete

 

[Max]

Try 2 ways?

a. For a one-time transpose job

Select A1:A26
Click Copy
Right-click on B1 > Paste Special > Transpose > OK
(this transposes A1:A26 into B1:AA1)

Select col A
Click Edit > Delete

b. Using TRANSPOSE

Assuming same source range A1:A26 (ie a 26R x 1C grid)

Select B1:AA1 (range selected must be a 1R x 26C grid)
Put in the formula bar: =TRANSPOSE(A1:A26)

Array-enter the formula:
Hold down CTRL + SHIFT, press ENTER
(instead of just pressing ENTER)

Whatever's showing in A1:A26 will be transposed into B1:AA1

Above useful if its not just a one-time operation,
for e.g. if A1:A26 contains values from formulas
which may change, etc and you need the
corresponding changes in B1:AA1

 

[billQ]

Look at the transpose function. Be aware that the transpose function must
be placed as an array fuction. ie.
choose the range where the data will be placed and type,
=Transpose(rangeToTranspose) then press ctl+shift+enter
Note: one range must have the same number of rows as the other has columns.
HTH
bill

 

[howardh]

Thanks to all.

i just tried it and it works great.

-howard

 

[Earl Kiosterud]

Just an added note. Using the transpose function means that the transposed
data is linked to the original data, which means it must remain. With the
Paste special - Transpose procedure, you get a copy of the original data,
and can remove the original data.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Look at the transpose function. Be aware that the transpose function must
be placed as an array fuction. ie.
choose the range where the data will be placed and type,
=Transpose(rangeToTranspose) then press ctl+shift+enter
Note: one range must have the same number of rows as the other has columns.
HTH
bill