Transfering numbers into a row

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

Hi

is there a way to move or copy a column of
numbers in cells into a row of cells?

thanks

Daniel
 
Copy the column, put cursor where you want it to go, select Paste-Special,
Transpose

Excel XP.
 
HansM,

How about my "expanded version of this problem"? It would be involving
several thousand rows so copy paste is not an option.

Thanks

Travis


FROM THIS

F1 F2
12345 VA7X
12345 40-5
12345 M5
12345 CXT1
12346 50-3
12347 VM8X
12347 VM25C



TO THIS

F1 F2 F3 F4 F5
12345 VA7X 40-5 M5 CXT1
12346 50-3
12347 VM8X
12347 VM25C
 
In
REM7600 said:
HansM,

How about my "expanded version of this problem"? It would be
involving several thousand rows so copy paste is not an option.

Thanks

Travis


FROM THIS

F1 F2
12345 VA7X
12345 40-5
12345 M5
12345 CXT1
12346 50-3
12347 VM8X
12347 VM25C



TO THIS

F1 F2 F3 F4 F5
12345 VA7X 40-5 M5 CXT1
12346 50-3
12347 VM8X
12347 VM25C
Click to expand...

.... Try something like this and modify to suit:
Put in Sheet2!A2:
12345
12346
12347
12348

Put the formula in Sheet2!B2:
(credit: Soo Cheon Jheong)
=IF(COUNTIF(Sheet1!$A:$A,$A2)<COLUMNS($B2:B2),"",
OFFSET(Sheet1!$A$1,MATCH($A2,Sheet1!$A:$A,0)+COLUMNS($B2:B2)-2,1))
 
use
edit-copy-edit-pastespecial-values-transpose

But there can only be 256 columns and therefore can only be 256 rows.

question not clear.
 
Back
Top