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
>