I have an Excel Sheet that has data I want to sort alphabetically in even
numbered rows and comments about the data in odd numbered rows. How can I
sort data in Row 2 for example and have Row 3 move with it?

Row 2 has lots of cells across with personal data relating to people and Row
3 is a single cell with text that goes completely across the legal page.

Row 1 is the header row with labels for the data. Also this sheet has about
400 excel lines down the page.

Thanks in advance if you can help me.....