In the Sort dialog box, under Column, in the Sort by or Then by box, pick out the column that you might want to sort by a custom record. I found a completely new macro that promised to automate a very frustrating process, preserve me a lot of time and https://www.customguide.com/google-sheets/how-to-merge-cells-in-google-sheets