Transform row to a column

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

"dealwi8me" <dealwi8me.290p9b_1149659401.2147@excelforum-nospam.com> wrote
in message news:dealwi8me.290p9b_1149659401.2147@excelforum-nospam.com...
>
> 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
> ------------------------------------------------------------------------
> dealwi8me's Profile:
> http://www.excelforum.com/member.php...o&userid=18854
> View this thread: http://www.excelforum.com/showthread...hreadid=549315
>

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.

dealwi8me wrote:
>
> 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
> ------------------------------------------------------------------------
> dealwi8me's Profile: http://www.excelforum.com/member.php...o&userid=18854
> View this thread: http://www.excelforum.com/showthread...hreadid=549315

--

Dave Peterson

Nice, thanks!

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:4486BCCA.A1A276BF@verizonXSPAM.net...
> 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.
>
> dealwi8me wrote:
>>
>> 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
>> ------------------------------------------------------------------------
>> dealwi8me's Profile: http://www.excelforum.com/member.php...o&userid=18854
>> View this thread: http://www.excelforum.com/showthread...hreadid=549315
>
> --
>
> Dave Peterson