Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to separate large verticle data set into columns with 50 entries
Hopefully someone can help me with this. I have a large data set (2500 entries) in two verticle columns, i.e. x value1, y value1 x value2, y value2 . . . . xvalue2500, y value2500 I need to tabulate this data set for printing, i.e. 14 columns with 50 entries in each on each page. This is incredibly painstaking to do manually. Does anyone know if there is a function to do this for me? I want something to cut the data set into groups of fifty and align them side by set. Any ideas? Help will be greatly appreciated. -- cathalog ------------------------------------------------------------------------ cathalog's Profile: http://www.excelforum.com/member.php...o&userid=32609 View this thread: http://www.excelforum.com/showthread...hreadid=524054 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH UP DATA IN COLUMNS | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Can I use Excel to match text data from 2 separate columns ? | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) |