Hi. I have a business spreadsheet with data tables in multiple rows. However, certain rows in the spreadsheet are linked to different directors and I need to sort the data. How can I sort data such that rows are linked together/won't shuffle and will sort by the name of the director in the first cell without ruining the order of rows after it belonging to that director? I've attached a sample of what I have so far to organize.
Solved by S. S. in 15 mins