Can I sort into sections on Excel 2003?

E

Eli Luong

I have data that looks something like this, in two columns (each row
here represents a column, to make it simipler)

A1, A2, A3, B1, B2, D2, E1
A2, A4, B2, C3, C4, D1, D2

Is there a way to sort the table so that everything is grouped into
alphabetical sections? Something that looks like this:

A1, A2, A3, B1, B2, [space], D2, [space], E1
A2, A4, [space], [space], B2, [space], C3, C4, D1, D2, E1

I'm not sure if that is clear, but I want all the cells that begin
with A to be grouped. The data in each column is not related. I just
want to compare the two columns to see if things in column 1 are
present in column 2, and it would be easier if things were organized
into the alphabetical character subheaddings.

Thanks,
- Eli
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top