View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
anyole anyole is offline
external usenet poster
 
Posts: 9
Default sorting datasets on two rows

if one set of data record is on two rows, how do i sort it so that the rows
retain data relevant to the dataset? eg.

Albion Gate
Albion Street W2 2LA
Alcazar, The
Phoenix Street WC2H 8BS
Alcove
Napier Place W14 8LG
Alders, The
Aldrington Road SW16 1TP
Aldershaw
Watkinson Road N7 8EX
Aldgate Barrs
Whitechapel High Street E1 7PJ
Alfred Villas
Barrett Road E17 3NB

whe
Albion Gate
Albion Street W2 2LA

belong to the same data record.

Thanks a lot
anyole
--
ino ne sauti ya anyole okhurula ebusikhale emmayoka. orakhaenda omwoyo tawe.
khuli halala. nyasaye akhulinde. embwo