Transfer / combining Excel data
 

I have a data worksheet created in excel with a column containing 5 digit
serial numbers, up to 300 diferent serial numbers (in individual rows). I
have the data sorted in assending order based on serial number column.
Serial numbers are random and not consecutive (ie. 05943, 05944, 05945,
05968, 05988 etc..)

1) I need to be able to select all the serials and transfer them to another
worksheet in excel, placing them in one cell, table, or ? - for purpose of
issuing a certification to our customer listing all the serial shipped- is
this possible?

2) If they can be in be transfered, is there a formula that would list them
in ranges instead of all 300 serial numbers? (ex. 05943 thru 05945, 05968,
05988 thru 06112 etc...)