title: How to sort multiple rows in Excel and how to tell Excel that two rows are one
body: <p>I want to sort this sheet by party name but the problem is, I want to sort both rows by party name and in ascending order. b2 and b3 are the elements of the partyname, so I want to sort both rows on party name. Is there any way other than VBA to sort on multiple columns?</p>
  
  <p>UNSORTED</p>
  
  <p><a href="https://i.stack.imgur.com/eXB74.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eXB74.jpg" alt="1"></a></p>
  
  <p>SORTED</p>
  
  <p><a href="https://i.stack.imgur.com/beqFg.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/beqFg.jpg" alt="2"></a></p>