How to sort groups of rows in Excel

In my day job, I work with a software
product that universities use to manage the
business of running a university (such
software packages are called ERP's, which
stands for Enterprise Resource Planning, and
the name of the product is Colleague, put
out and supported by a company called
Ellucian.)

The ERP has screens (i.e. web pages)
university staff and faculty use to access
and maintain information in the ERP. Each
web page/screen is accessed by either
clicking directly on the screen's
name/description on the ERP's UI menu, or by
directly entering what Ellucian calls a
mnemonic, which is usually just a short,
unique acronym for the description of the
screen.

I keep a text file list of some of the more
useful mnemonics and their descriptions for
quick access to them, especially the ones I
use infrequently.

Part of the list is shown below (after I've
pasted it into Excel):



I usually just append new entries to the
list, but now there are so many, I felt it
would be nice to copy the list and paste it
into Excel and sort it, and then copy the
sorted list back into my mnemonic list text
file.

So that's what I did, thinking it would be a
small matter to sort it alphabetically. I
soon learned sorting lists that look like
what's shown in the example, is not
something easily done in Excel.

I searched Google for "How to sort groups of
rows in Excel", and what I found is that
apparently there is nothing built into Excel
that allows sorting groups of a fixed number
of rows, using the first row of each group
as what to sort by.

I did find many suggestions on adding
columns to the spreadsheet, so as to use
them for sorting, but either nothing
perfectly addressed what I wanted to do, or
suggestions were overly complicated.

I'll explain more about what I ended up
doing below this next image, which resulted
in a sorted list, using the first row of
each group as the key, while maintaining the
fixed number of rows for each group:



I did have to add two new columns (B and
C)... there's just no way around it, but
once I worked out the formulas, it wasn't
very complicated at all, and I got the exact
results I was looking for.

Here is the formula for column B:
=INDIRECT("A"&ROW() - ((IF(MOD(ROW()-4,7)=0,
7, MOD(ROW()-4,7)))-1))

Here is the formula for column C:
=(IF(MOD(ROW()-4,7)=0, 7, MOD(ROW()-4,7)))

Obviously, adjust the formulas if you're
using different columns.
Also, my list starts at row 5, and each
group is 7 rows deep. So if your list starts
at a different row, replace all the 4's in
the formulas with your starting row MINUS
ONE.
And if your number of rows making up each
group is more/less than 7, then change all
the 7's with your number of rows making up
each group to be sorted. Your list can start
on any row (assuming you change the formulas
accordingly), and all the groups can be any
number of rows each, BUT EACH GROUP MUST BE
MADE UP OF THE SAME COUNT OF ROWS.

The formula for column B calculates the row
that is the first row of any particular
group, and pulls its column A value into
each column B cell.

The formula for column C just calculates
which row of 7 that particular row appears
in.

Paste these formulas into columns B and C of
the first row of the first group in the
list, and then using Excel's Home > Editing>
Fill, copy them DOWN to the rest of the
column B/C rows/cells.

Finally, to sort the list, use the Data >
Sort function, and make the dialog box that
pops-up, look like this:



Before actually sorting the list (i.e.
clicking the dialogue box's "OK" button),
make sure to set the "My data has headers"
checkbox accordingly, and click the "Sort >
Options..." tab to set the "Sort top to
bottom" radio button as well.

Click "OK", and you should end up with
something similar to what's showing in the
second image above.

Once you're done copy all of column A, and
paste it into your original text file, or
just name the spreadsheet, save it, and use
it instead.

Use the comments if you have any questions
or issues to report.

Hope this helps, and thanks for reading.

0 comments, click here to add the first

Read the memo: Amazon's grocery boss details restructuring, says more 'deliberate' strategy needed

Furnished content.


Amazon's top grocery executive Jason Buechel told staff that the company needs to make more "deliberate choices" to win over customers.

Read more here

0 comments, click here to add the first

Move over, Claude: Moonshot's new AI model lets you vibe-code from a single video upload

Furnished content.


While it's not yet clear how practically useful the capability will be for individuals and businesses, the model's "coding with vision" capability makes vibe coding even vibier.

Read more here

0 comments, click here to add the first

Need to manage virtual machines on Linux? I found an easier way

Furnished content.


If you're looking for a way to manage virtual machines on Linux and even do it remotely, Cockpit is what you want.

Read more here

0 comments, click here to add the first

Intel says it will match government's 'Trump Accounts' contribution to kids of employees

Furnished content.


The 530A program, often called "Trump Accounts," passed last year as part of the administration's "big beautiful bill."

Read more here

0 comments, click here to add the first

AppLovin demands short-seller CapitalWatch retract 'conspiratorial' report

Furnished content.


AppLovin's cease and desist letter to CapitalWatch called the short-seller's accusations of money laundering defamatory and baseless.

Read more here

0 comments, click here to add the first

I tried an automatic roll-up pet door, and it was the smart home fix I didn't know I needed

Furnished content.


Busy dog owners, rejoice. This clever smart pet door makes letting your dog out a breeze.

Read more here

0 comments, click here to add the first

The only Linux command you need for monitoring network traffic - and how to use it

Furnished content.


Recently, I needed to check on incoming and outgoing traffic to one of my Linux machines. Fortunately, there's an easy way to do just that.

Read more here

0 comments, click here to add the first

TikTok users are deleting the app, with removals up 150% following U.S. joint venture

Furnished content.


TikTok users have been deleting the app at a higher rate since the company announced that its U.S. operations would be housed in a new joint venture.

Read more here

0 comments, click here to add the first

Microsoft's plans for 15 more data centers win approval at former Wisconsin Foxconn site

Furnished content.


Microsoft intends to expand in a place where it's been welcomed, months after backing down on a rezoning attempt in an adjacent village when residents objected.

Read more here

0 comments, click here to add the first

Meta to test premium subscription plans for Instagram, Facebook and WhatsApp

Furnished content.


Meta Platforms is set to test new subscription models across its apps, including Instagram, Facebook and WhatsApp in the coming months.

Read more here

0 comments, click here to add the first

How to file your taxes for free in 2026 - 4 ways to do it (despite Direct File's demise)

Furnished content.


The IRS's Direct File Service is no more, but most taxpayers can use one of these free options to prepare their 2025 returns - even if you itemize deductions.

Read more here

0 comments, click here to add the first

Why you need Microsoft's new emergency Windows patch - and the black-screen bug to watch for

Furnished content.


While Microsoft has been fixing bugs caused by the Patch Tuesday update, another glitch has surfaced.

Read more here

0 comments, click here to add the first