Merging or Combining

W

woodhick

Hi all, I am having some difficulty trying to combine two worksheets
The worksheets have identical headings, but the data is different, I'l
try to explain: worksheet 1 has data such as this:

A B
1 1
1 3
1 5
2 1
2 3
3 1
3 3
3 5

worksheet 2 would have:

A B
1 2
1 4
1 6
2 2
2 4
3 2
3 4
3 6

and so on.

I need to get the data merged or combined into one worksheet so tha
the odd and even ends correspond with the correct row, like this:

A B
1 1
1 2
1 3
1 4
1 5
1 6
2 1
2 2
2 3
2 4
3 1
3 2
3 3
3 4
3 5
3 6


Sorry for being so simple, but that is how I could best describe what
need. Anybody care to help me
 
W

woodhick

I figured it out, I copied both worksheets to a new worksheet and th
just sorted by the first two columns. It is my luck that after two day
of trying to get it to work, I finally post a message, then I figure i
out, what an idiot I am.:
 
Top