Copy only visible values in column

I have a spreadsheet containing a number of columns and around 500 rows of data two of the columns are 'train ID' and 'cost'. There are several entries for each 'train ID' so I want to group these together and get a total cost for each 'train ID'. Then sort these totals in order to give me the most expensive 'train ID' at the top running down to the least expensive at the bottom. I have sorted the data by 'train ID' then run subtotals to give me
the total costs. However I want to now copy the list of totals (train ID & cost) onto another worksheet. If I copy the columns and then paste onto the other worksheet, all the hidden columns on the subtotal sheet appear aswell which is what I don't want. I have tried 'paste specials' and 'values'
but this also shows the hidden data aswell. I only want the totals for each 'train ID and its associated 'costs'. I hope this makes sense. Any help would be appreciated. Kevin.