| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shading multiple rows or, alternately, multiple columns only | Excel Discussion (Misc queries) | |||
| Convert data from multiple columns/rows into one column - help! | Excel Worksheet Functions | |||
| convert row to columns for multiple rows | Excel Worksheet Functions | |||
| Excel Convert Multiple Rows into Multiple Columns | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Threaded Mode
