Merging

[gary]

Cells A1..H65000 contain data.

Block #1 (A1..H32000) contains data related to various
part-numbers.

Block #2 (A32001..H41000) contains data related to
part-numbers which may be identical to or different from
those in Block #1.

Block #3 (A41001..H45861) contains data related to
part-numbers which may be identical to or different from
those in Blocks #1 and #2.

Block #4 (A45862..H61123) contains data related to
part-numbers which may be identical to or different from
those in Blocks #1, #2 and #3.

Block #5 (A61124..H65000) contains data related to
part-numbers which may be identical to or different from
those in Blocks #1, #2, #3 and #4.

I need to merge the data from the five blocks into one new
block. The part-numbers in this new block must be in
ascending order and the data for each part-number in the
new block must be kept in the same sequence as in the five
blocks.

How can I do this?

 

[Guest]

You'll have to identify which block each record comes from
first, either by (preferably) adding a column to hold
block number (1-5, A-E, whatever) or by modifying one of
the record fields to hold that info as a lead character.
Then you can combine and sort the records, on part number
ascending first, then by block number, ascending.