Hi,
I have a spreadsheet with the following columns:

Item # 1 to 1000
Account Number alphanumeric 20 characters long
Amount 1
Amount 2
Period 1
Period 2

Data is currently sorted by Amount 2 ( largest to smallest).

There are multiple entries for the same account.

What I want to do is now group the data so that All the same account
numbers are grouped together along with all other fields but in this
grouping I want the amounts to keep the current sort largest to
smallest ( largest to smallest).If an account as three numbers I want
them on the sheet in consecutive lines

Thanks for all your help,