How do I sort an Excel sheet by a certain column, but keep all the data in each row together?

You need to create something called a list. Select the entire database and create a list with it. There should then be drop down boxes at the top of each column which will allow you sort. All of the rows should then be linked.