Consolidating subtotals

[bon]

After subtotataling a spreadsheed of rows of customers by state and using the count function I am left with 50 states and a qty of customers in each. I would like to use that data only in another spreadsheet but when I copy-paste it actuall brings over all 4000 rows. I would like only to utilize the new 50 rows of state and count.
Thanks

 

[bon]

Still having trouble with using only the subtotaled data in a separate worksheet. Cannot copy/ paste as it wants to grab the underlying rows also. I only want the subtotaled data as my final data.

Thanks