| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Turning rows of equal number of columns into 1 continuous row
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... Befo A1 B1 C1 D1 E1 A2 B2 C2 D2 E2 A3 B3 C3 D3 E3 After: A1 B1 C1 D1 E1 A2 B2 C2 D2 E2 A3 B3 C3 D3 E3 Is there any way to automate some of this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cutting and pasting from rows into columns and visa versa. | New Users to Excel | |||
| find number in multiple columns and rows | Excel Worksheet Functions | |||
| turning rows into columns? | Excel Discussion (Misc queries) | |||
| NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
| How do I change the number of columns and rows in a worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
