I'M WORKING ON A NEW FORMAT AND NEED TO FIND OUT HOW TO SORT THE 5 LINES THAT REPRESENT ONE CUSTOMER TOGETHER AT THE SAME TIME.
i.e. SALES CATEGORY CODE
CUSTOMER 1 TYPE 1 2
TYPE 2
TYPE 3
TYPE 4
TYPE 5
CUSTOMER 2 TYPE 1
TYPE 2
TYPE 3 4
TYPE 4
TYPE 5
NOW HOW CAN I SORT THE GROUPS BY AN COLUMN I WANT AND STILL KEEP THE CUSTOMER TOGETHER AS A WHOLE?
i.e. SALES CATEGORY CODE
CUSTOMER 1 TYPE 1 2
TYPE 2
TYPE 3
TYPE 4
TYPE 5
CUSTOMER 2 TYPE 1
TYPE 2
TYPE 3 4
TYPE 4
TYPE 5
NOW HOW CAN I SORT THE GROUPS BY AN COLUMN I WANT AND STILL KEEP THE CUSTOMER TOGETHER AS A WHOLE?