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
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