Is it possible to automatically move data entered in columns into rows?

  • Thread starter Richard Thorneycroft
  • Start date
R

Richard Thorneycroft

Is it possible to automatically move data entered in columns into rows?

It seems like a simple thing to do but I can't find a function anywhere.

Cheers,

Richard Thorneycroft
Husky Products
 
D

Don Guillett

If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
 
G

Guest

sounds like you are talking about tranposing the data
edit>paste special> transpose.
the automatic part is a little foggy. you need to know
where you are going to tranpose the data.
 
R

RagDyeR

It depends on what you mean by "automatically".

You could try "Transpose".
Select a column of data.
Right click in the selection and choose "Copy".
Right click in a cell where you wish to start the row of data, and choose
"PasteSpecial".
Click on "Transpose", then <OK>.

Don't forget ... you only have 256 columns, so you can only copy (transpose)
256 rows at a time.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Is it possible to automatically move data entered in columns into rows?

It seems like a simple thing to do but I can't find a function anywhere.

Cheers,

Richard Thorneycroft
Husky Products
 
D

Darlene Kupke

Is it possible to automatically move data entered in columns into rows?

It seems like a simple thing to do but I can't find a function anywhere.

Cheers,

Richard Thorneycroft
Husky Products
Click to expand...
Hi

Try making a copy of the columns on a fresh worksheet. Then copy the column
and paste in another location using paste special transpose. It will turn
columns into rows and rows into columns. I always experiment on a trial
copy so if it's a mess you can try again.

bye

Darlene
 
R

Richard Thorneycroft

Yeah sorry, a bit of a rushed post there.

If data was entered in Column 'A' in rows 1 to 26 and I wanted to
change it to being in Row 1 in columns 'A' to 'Z'.

I've got it now using the Transpose function.

Thanks everyone.
 
Top