In this video, we’ll look at a basic example of sorting with the SORTBY function. With the SORTBY function, you supply sort order in pairs of inputs. Each pair has an argument for range, and an argument for sort order.
In this video we show you how to use merge to align text across cells. Merge is easy and works well, but be sure to check out Center Across Selection for an option that doesn't interfere with Excel's grid.