Rows to Columns

B

bob

Hi
I have been looking for a way to transfer a row of data to a column i.e. a1 to a1 b1 to a2 c1 to a3 etc. is there a process or formulae available
 
F

Frank Kabel

Hi
have a look at 'Edit - Paste Special - Transpose' for this

--
Regards
Frank Kabel
Frankfurt, Germany

bob said:
Hi
I have been looking for a way to transfer a row of data to a column
Click to expand...
i.e. a1 to a1 b1 to a2 c1 to a3 etc. is there a process or formulae
available
 
M

Max

Another option ..

Assuming your original data is residing in Sheet1

In a new Sheet2
----------------------
Put in A1: =OFFSET(Sheet1!$A$1,,ROW(A1)-1)

Copy A1 down

The above will link to / return what's in Sheet1's row1
(i.e.: the contents in A1, B1, C1, etc...)
but in a columnar fashion that you want

And for a neater look, extraneous zeros can
be suppressed from showing in Sheet2 via:
Tools > Options > View tab > Uncheck "Zero values" > OK
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
bob said:
Hi
I have been looking for a way to transfer a row of data to a column i.e.
Click to expand...
a1 to a1 b1 to a2 c1 to a3 etc. is there a process or formulae available
 
Top