If you are unable to or cannot insert Columns with right-click in an Excel spreadsheet, then read the following to set things right again.

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY formula. Alternatively, to extract, filter, and sort columns from a dataset ...

Delete enough rows or columns to make room for what you want to insert and then try again. Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet ...