Combining data with multiple row entries XL07

[vince1988]

Hello,
I'm using Xl 07 and need to combine two sheets of contact info and have them sorted alphabetically.

Each contact entry takes the follwing form(comma's denote new columns)

55555, Name , John, Smith, Tel: , 555-555-5555
ID , Company, XXX , , Email, xxxxxx

Each sheet has a list of 200 or so entries about 400 rows long. The entries on each sheet are sorted in alphabetical order. the names also alternate alphabetically from sheet to sheet. So when i look at the entries on my final sheet, the 1st will be from sheet1 the second from sheet2 the third from sheet1 and the fourth from sheet2 etc.

I'm not sure whether I should build a new list by pulling alternating entries from each sheet or just copy one list below the other and then try to sort it somehow.


Thanks for your time and any help is appreciated,

Vince

 

[venkat1926]

you can do either of them