This is an entry more for my record keeping than any other reason. The question is how to best create summary tables in Excel. The data I have has a row for each customer and sets of columns for each month. Each customer row had data in only one set of columns. Subtotal gives an easy way to consolidate this data onto a single line. The problem comes in that if you copy the excel data with the sub-rows hidden they show up in the pasted data
The solution: This only happens if you paste into Excel. Paste into a text editor, select all and paste back into Excel and voila. All is good.