Thread: Sort list combining 2 columns of parent and childrens in excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
morvi morvi is offline
external usenet poster
  
Posts: 1
Default Sort list combining 2 columns of parent and childrens in excel
I have a list of records with ID's and parent_ID

[ID ][Parent ID] ...
[ 1 ][ 0] ...
[ 2 ][ 4] ...
[ 3 ][ 4] ...
[ 4 ][ 6] ...
[ 5 ][ 6] ...
[ 6 ][ 15] ...

.....

Is there a way to sort it so that parents are listed on top (above) of the
children
[ID ][Parent ID]
[ 1 ][ 0]
[ 4 ][ 6]
[ 2 ][ 4]
[ 3 ][ 4]
[ 6 ][ 15]
[ 5 ][ 6]



Reply With QuoteReply With Quote