Final answer:
To sort columnA result by columnB, use a secondary sorting method. First, sort based on columnA, then apply another sorting command for columnB.
Step-by-step explanation:
To sort columnA result by columnB, you can use a secondary sorting method. First, sort the data based on columnA using the '| top columnA' command. Then, apply another sorting command to sort the sorted data based on columnB.
For example, if you're working with an Excel spreadsheet, you can select the data range, go to the 'Sort & Filter' option in the 'Data' tab, and add a second sorting level for columnB.
This way, the data will be sorted first by columnA. In case of ties, it will then be sorted by columnB.