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 B. D. in 16 mins