Transpoing: 2 columns=>1 row

F

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.
 
B

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
 
Top