Please note that the software always sorts by last name, so when including companions, the main and companion guests are not only listed together by the same last name.
If you export including companions and sort by the column "Main Guest Access Code" in ascending or descending order, the main guests and their companions will be sorted directly under each other, giving you the desired result.