Transpoing: 2 columns=>1 row

[Fotop]

Hi everyone, this is probably simple but I just dont know which way to attack the problem.

I have 2 columns:

A 1
B 2
C 3
D 4

I need them to be 1 row:

A 1 B 2 C 3 D 4

Thanks in advance.

[Biff]

Hi!

Assume your data is in the range A1:B4

Enter this formula in the first cell where you want the transposed data to
appear:

=OFFSET($A$1,INT((COLUMNS($A:A)-1)/2),MOD(COLUMNS($A:A)-1,2))

Copy across as needed.

Biff

"Fotop" <[email protected]> wrote in
message news:[email protected]...
>
> Hi everyone, this is probably simple but I just dont know which way to
> attack the problem.
>
> I have 2 columns:
>
> A 1
> B 2
> C 3
> D 4
>
> I need them to be 1 row:
>
> A 1 B 2 C 3 D 4
>
> Thanks in advance.
>
>
> --
> Fotop
> ------------------------------------------------------------------------
> Fotop's Profile:
> http://www.excelforum.com/member.php...o&userid=27880
> View this thread: http://www.excelforum.com/showthread...hreadid=473843
>