ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort list combining 2 columns of parent and childrens in excel (https://www.excelbanter.com/excel-discussion-misc-queries/151466-sort-list-combining-2-columns-parent-childrens-excel.html)

morvi

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]





All times are GMT +1. The time now is 12:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com