Chain Sorting

[jt98]

Hi all, I have a data where currently it is all sorted and I have over 2 million records. There is a parent ID and can have multiple children and I want to sort them in a way where i can see the chain of each path like below:

Sale date	Parent ID	ID
2022-05-05		005
2022-05-05	005	008
2022-05-05	008	010
2022-05-05	010	017
2022-05-05	008	015
2022-05-05	015	019
2022-08-10		800
2022-08-10	800	865
2022-08-10	865	900
2022-08-10	900	58

Using a normal sort wont work as it will sort ascending and will not show the chain effect. Maybe I could use iterative macro but im not familiar with it. 

Thanks in advance for any help!

[gawa]

Hi @jt98 

This would not be exactly solution to your question, but if you want "Chain", then try iterative macro like attached workflow.

[Amol_Telore]

@jt98 , will you be able to share some sample input data?