I am working with a table that I need to sort, while keeping the data in a row the same. Column A has an array function connected to a different sheet, and based off that sheet, column A can change. When this happens though, the other rows do not stay with the original data. Here's an example...