Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to transpose 1422 values from a column to row
Is it possible? since we dont have 1422 columns, how would the data be
transposed? Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to transpose 1422 values from a column to row
You would have to transpose it in 1422/255 rows.
Or, download XL 2007 beta which has 16000 rows. Dave -- Brevity is the soul of wit. "Gary" wrote: Is it possible? since we dont have 1422 columns, how would the data be transposed? Thanks in advance. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need to transpose 1422 values from a column to row
This macro will transpose the 1422 cells to 5.6 rows but unless you wait for
Excel 2007 which has 16,384 columns, you cannot squeeze the 1422 into one row. Sub ColtoRows() Dim Rng As Range Dim I As Long Dim j As Long Dim nocols As Long Set Rng = Cells(Rows.Count, 1).End(xlUp) j = 1 On Error Resume Next nocols = 255 For I = 1 To Rng.Row Step nocols Cells(j, "A").Resize(1, nocols).Value = _ Application.Transpose(Cells(I, "A").Resize(nocols, 1)) j = j + 1 Next Range(Cells(j, "A"), Cells(Rng.Row, "A")).ClearContents End Sub Gord Dibben MS Excel MVP On Fri, 22 Sep 2006 08:43:18 -0600, "Gary" wrote: Is it possible? since we dont have 1422 columns, how would the data be transposed? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Lookup values in one column to return another | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How sum values in column B using values in column A as the conditi | Excel Worksheet Functions |