View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
justlearnin justlearnin is offline
external usenet poster
 
Posts: 14
Default Sorting rows by pairs

I have a spreadsheet that I need to do some sorting where the information for
each person is on 2 lines. I need to keep the grouped info together. Also,
when I imported this data, it had put to sections together that should have
been seperated. When I do this sort, I would have to eliminate the first 6
spaces. Any help would be greatful. Thanks. Here is an example of what is in
each row:
Row 1:
73.26 0829. DAWSON,ANGELA K D 508347 3 62 4100557000048 070106
073106 167.20 167.20 0.00 0.00 167.20
Row 2:
PROC CO DE - MODIFIER T2002 - U3 070106 073106 167.20 167.20