Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying multiple rows to columns
i need to copy every 4th row and put it in its own column while using the
first row in each new column as its name. eg. pepole fruit boy apple girl pear man mango fruit apple pear mango |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying multiple rows to columns
calvin wrote:
i need to copy every 4th row and put it in its own column while using the first row in each new column as its name. eg. pepole fruit boy apple girl pear man mango fruit apple pear mango This might work for you: If the "master list" is in A1:Ax and you want to bump 4 rows at a time into B1:B4, C1:C4, etc., try one of these formulae in B1:B4 and fill right as needed: =INDEX($A$1:$A$x,4*(COLUMN()-1)+ROW()) [fix $A$x to suit your range] =OFFSET($A$1,4*(COLUMN()-1)+ROW()-1,) [no adjustment required] |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying Columns of Data to Rows | Excel Discussion (Misc queries) | |||
copying information from rows to columns | Excel Discussion (Misc queries) | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
Copying from columns to Rows | Excel Discussion (Misc queries) | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) |