CHOOSECOLS is the function you need to use to extract data from the Shop and Tot columns, Sales is the name of the table containing the array, and [#ALL] tells Google Sheets that you want the ...

Force header columns and rows in Numbers to stay still and visible while you scroll across the rest of the spreadsheet.