It would save users a significant amount of time if Total and Blank rows did not show when you copy data our of a an Ad Hoc Analysis ranked report. This data is likely dropped into excel and in order to pivot the data, these rows must be removed. Can you please remove the rows that are totals and blanks?