Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quickly moving rows of 5-column groups on 1 continuous line
I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a
5x50 grid). I'm trying to turn this into 1 continuous row that uses data from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3... Is there any way to automate some of this? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quickly moving rows of 5-column groups on 1 continuous line
I assume you want the value from A1 in Column A, From B1 column B... From A2
in Column F, from B2 in Column G etc. if so go below your data (Say row 100) and in A1100 enter =INDIRECT("A"&CEILING(COLUMN()/5,1)) in B100 enter =INDIRECT("B"&CEILING(COLUMN()/5,1)) continue to column E putting in appropriate letters. copy A100:E100 and copy out to 250 columns. "C.O." wrote: I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a 5x50 grid). I'm trying to turn this into 1 continuous row that uses data from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3... Is there any way to automate some of this? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Quickly moving rows of 5-column groups on 1 continuous line
Hi!
One way: Assume your data is in the range A1:E50 Enter this formula in some cell and copy across as needed: =OFFSET($A$1,INT((COLUMNS($A$1:A1)-1)/5),MOD(COLUMNS($A$1:A1)-1,5)) Biff "C.O." wrote in message ... I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a 5x50 grid). I'm trying to turn this into 1 continuous row that uses data from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3... Is there any way to automate some of this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
need help righting script to sort rows alphabetically then seperate them to line up | Excel Worksheet Functions | |||
redistribute a column by a groups of rows | Excel Worksheet Functions | |||
moving alternating rows to a column with the order staying the sam | Excel Discussion (Misc queries) |