Need to separate large verticle data set into columns with 50 entries

C

cathalog

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 5
entries in each on each page. This is incredibly painstaking to d
manually.

Does anyone know if there is a function to do this for me? I wan
something to cut the data set into groups of fifty and align them sid
by set.

Any ideas?

Help will be greatly appreciated
 
J

JE McGimpsey

One way:

C1: =INDEX($A:$B,INT((COLUMN()-1)/2)*50+ROW(),2-MOD(COLUMN(),2))

Copy C1 to C1:CV50



Copy over to In article
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a chart to large workbook brings workbook activity to a hal 6
Pivot Table - Easy way to add multiple Columns into Data section? 6
Transpose large data from columns to rows 3
Sorting problem 3
LINEST with filtered data 5
Showing data unigue to multiple columns in a pivot table 1
Columns, All Data In 5
Problems with working out averages with large amounts of data 6

Top