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!
