..:: Can this be done ::..

D

dealoflove

say i have two worksheets and on two worksheets I have
n rows each and I wanted it merge in such a way that there are 2n rows
in the new worksheet and in the new work sheet the rows should be in
such manner that the row1 of worksheet one appears first then row1 of
worksheet two and so on for example

worksheet 1

r1 : 1 2 3 4 1 2 3 4
r2 : 2 1 2 2 5 6 2 3

Worksheet 2

r1: 2 4 2 2 5 6
r2: 2 3 4 5 6 1


resultant worksheet

r1 : 1 2 3 4 1 2 3 4 <---- This is of worksheet one
r1: 2 4 2 2 5 6 <---- this is of worksheet two
r2 : 2 1 2 2 5 6 2 3
r2: 2 3 4 5 6 1


any software any thing which can help please suggest
 
P

PY & Associates

copy worksheet2 to end of worksheet1
add column A
enter 1, 3 in cells A1, A2
copy down to row n
enter 2,4 in rows n+1 and n+2
copy down to row 2n
sort the whole sheet by column A in ascending order
delete column A
 
B

Bill Ridgeway

You could add a helper column to each spread sheet. In the spreadsheet you
want to appear first, add the numbers 1,3,5 etc and in the spreadsheet you
want to appear second, add the numbers 2,4,6. (This can be done easily by
typing in the first two numbers and dragging down to autofill). Copy and
paste one spread sheet to the other (it doesn't matter which way round) and
sort on the helper column. delete the helper column and job done!

Regards.

Bill Ridgeway
Computer Solutions
 
Top