I'm looking to find a way to group/sort data based on a 2 serial numbers, in this case called Demand Number and Supply Number.
The logic I'm trying to apply is if an items supply number matches the demand number of another item then it should be shown underneath it for example if you were to sort the data shown below:
You would get the following result:
I think I will need to use some helper columns, to apply 'levels' to the items but I'm really not sure where to go.
Thanks for the help!!
Data as text: