Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|