| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Convert Multiple Rows into Multiple Columns
Hi All,
I need some help with converting my excel data from multiple rows to multiple columns. Say i have a long list of serial numbers in a single column, like this: 10000 10001 10002 10003 10004 10005 10006 ..... 19999 How can i convert it to columns of data, like this? 10000 10005 10010 ..... 10001 10006 10011 .... 10002 10007 10012 .... 10003 10008 10013 .... 10004 10009 10014 .... I need each column having a specific numbers of rows, say 40, before the data continues to the next column. Is there any functions other than Macro programming? Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Freezing multiple rows/columns in Excel 2007 Pro | Excel Worksheet Functions | |||
| Convert multiple columns into one long row | Excel Discussion (Misc queries) | |||
| Easy way to convert multiple columns into one | Excel Discussion (Misc queries) | |||
| Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Threaded Mode
