Transform row to a column

  • Thread starter Thread starter dealwi8me
  • Start date Start date
D

dealwi8me

Hello all,

Can i make values that listed in a a row, to shown in a column
automatically?

for a example cells A1:1 B1:2 C1:3 D1:4 to become cells A1: 1 A2: 2
A3: 3 A4: 4.

Thank you in advance!
 
dealwi8me -

One way: Select A2:A4. In the formula bar type "=transpose(b1:d1)" (without
the quotes), but don't press Enter. Instead, hold down Ctrl and Shift while
you press Enter.

- Mike
www.mikemiddleton.com
 
Another way is to
Select the range
edit|copy
select the topleftcell of the receiving area
edit|paste special|click Transpose.

But the sending area and the receiving area can't overlap (like A1 in your
example). You can paste the data in a different location, then move it to its
final home later.
 
Nice, thanks!

Dave Peterson said:
Another way is to
Select the range
edit|copy
select the topleftcell of the receiving area
edit|paste special|click Transpose.

But the sending area and the receiving area can't overlap (like A1 in your
example). You can paste the data in a different location, then move it to its
final home later.
Click to expand...
 
Back
Top