Hi, thank you for contacting JustAnswer.com. My name is Russell. I will do my best to provide the right answer to your question.
What's the question, or what is it about, please? something has been generated, but what?
Let me know, and I will advise you to the best of my ability, or transfer you to another Expert who can or another category proper for your question.
That looks like a report on how many accounts per division, or the like.
What do you want to generate that from?
So you would generate a report like the first file you attached, from a list of unorganized and not-ordered BAL #s, that would count each BAL # in turn, and present a report in ordered and sorted format.
That's a database sort of operation, and I admit I do not know how to do that from an Excel-type spreadsheet with the data not at all ordered... so I have Opted Out, opening the case to other Experts in this category.