Re: Way to put multiple rows into the same column.

Peter Brown wrote:
I have data that is in the format of 3 columns wide by about 3000 rows. I want to rearrange each row to become a single column. Eg. Cells A1,B1,C1,A2,B2,C2 to become in cells A1,A2,A3,A4,A5,A6 respectively. I have transposed the data but this only puts each row in it's own column. I still need to put all the new columns into one column. Thankyou for any help given.
If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook you can array enter into D1:D9000:

=ArrayReshape(A1:C3000,9000,1)

Alan Beban
.

Relevant Pages

  • Way to put multiple rows into the same column.
    ... Enter this formula in cell A1 and copy down to A9000 or ... >want to rearrange each row to become a single column. ... >transposed the data but this only puts each row in it's ...
    (microsoft.public.excel.misc)
  • Re: Change Default Setting-Find & Replace-How?
    ... If all the occurrences are in a single row or a single column, ... Even find next has to look through the 100 cells. ... Excel tries to help by remembering the last settings you used--except ...
    (microsoft.public.excel.misc)
  • Re: Return Numeric Value to their Matched Value Position in Single Column
    ... I am using the following Formula to return 8 cells from my 18th row of "Data" ... from my 18th row of "Data" to a row in a single column that matches the value ... Numeric Value 45 should be returned to Position 45 in my column range N17: ...
    (microsoft.public.excel.worksheet.functions)
  • Array formula
    ... It's on the page "Eliminating Blank Cells From Lists" and the example ... I've been able to get it to work on a single column range as per the ... It successfully deals with the first row as a single unit, ...
    (microsoft.public.excel.programming)
  • Re: Breaking out data in a cell
    ... return text strings, so to convert to numbers you need to use a trick like ... I download a lot of stats via web queries. ... so cells in a single column with random data like "74th of 9354" without ...
    (microsoft.public.excel.worksheet.functions)