honestly think it ' s a combo of the two . I think Britain ' s postwar history of children ' s homes and orphanages for working class kids , as well as boarding schools for middleupper class people adds to it , but right now this is a crime that is very much in the spotlight so any story will inevitably get out . Also lots of these stories have been known by the media for years and come out much much later for whatever reason . <| sep |> Well no i have no value in my partner column because i want to choose the partner later . So its left blank but with a dropdown menu from which i can choose the partner . PIcture 1 You can see how i choose the partner from the dropdown menu , as normal . Picture 2 You can see how i changed the sorting to C B A right ? Now look at the dropdown menu , its dosnt follow . Did i make it more clear ? so if i fill out the partner info in the cell it follows . if i leave it blank the dropdown menu wont follow . no way to fix this ? final edit obviously my actual sheet is huge with many rows and columns . Every company on my list has 310 different partners , i want to be able to sort my big list of companies however i want , but still get the correct partners from the correct dropdown list for each and every company . No matter how the table is sorted So the dropdown menu needs to follow the company , not just being perm . to that one cell .