Transpoing: 2 columns=>1 row
 

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

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" wrote in
message ...

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