Good day!

I have a spreadsheet with over 300 shifts that have variables in each column. I need to choose groupings of 4 shifts based on (starting with) one column stating day of week (monday - friday) and they need to be 4 day work weeks. I would like to find it based on first, type of shift (in a different column) and then to first create schedules that factor in type of location (to keep workers at one location, but if not possible then to skip this preference). How would I get started doing this?