Adding Subheadings to List

I am certainly an Excel beginner but I have looked up and down this forum and others for a solution to this problem but I can't find anything.
I have a long list of items (around 2000) with about a dozen columns of data. One of the columns is titled 'Group'. The group names vary as you go down the list. So, this is what I'm trying to do with the list:

1. Sort by Group (easy part) creating 'sublists'
2. Add subheadings (group name) directly above each sublist

The idea is that when one sublist ends the next one begins, starting with its own subheading. And, if this isn't hard enough (hopefully easy to somebody), the number of items in each group will vary from time to time so each sublist will grow and shrink.
Any ideas?
-bd

Sandy
Thanks for getting back to me. I'm not sure I follow what you're saying but let me be a little more clear with this sample file. I added 2 tabs: raw data and organized data. I'm hoping there is a way to automatically organize the raw data in a format that appears like the organized data tab. Let me know what you think, thanks!
-bd

Got it, thanks for the help, Sandy! Pivot Table was the answer.

You are welcome

If that takes care of your original question, please click Add Reputation then select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Thanks for rep and mark thread solved