Then, from the Home menu, select Sort and Filter and then Custom sort.
The following screen will appear:
To sort this spreadsheet alphabetically by financial institution (which are contained in column A), in the Sort by box, choose Column A from the drop down list:
Then click OK. The data should now be sorted alphabetically by financial institutions in column A and the associated data should have remained alongside their relevant name. For example, the amounts in each column for Govt Bond 1 should be the same as it was before it was moved.
Unless a Custom Sort is chosen, data will always be sorted by the left hand column of the data selected.