How do I group multiple lines of excel info for easy sorting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ericsayang - 12 Jan 2006 16:15 GMT

I am putting a correspondence review in a big project. There are 7 columns:
Date, Form, From, To, Re:, Comments, Pages. Information in some of the
columns contain multiple lines. What I want to do is, I want to put the
information in and finally sort them according to dates. How do I group all
information for a specific correspondence so that when I sort all information
will be attached to the date. Thank you.

Reply to this Message

ufo_pilot - 12 Jan 2006 18:31 GMT

Seems like you have the date in the first column.
If not, it should be
Then select all cells: A2:G100
assuming your first date entry starts in A2 and is 100 rows down by 7
columns wide)
select the "sort -Ascending or Descending- icon" on the toolbar ( A over
Z with an arrow to it's right).
HTH

> I am putting a correspondence review in a big project. There are 7 columns:
> Date, Form, From, To, Re:, Comments, Pages. Information in some of the
> columns contain multiple lines. What I want to do is, I want to put the
> information in and finally sort them according to dates. How do I group all
> information for a specific correspondence so that when I sort all information
> will be attached to the date. Thank you.

Reply to this Message

Gord Dibben - 12 Jan 2006 20:06 GMT

The only way to keep a set of data like this together is to have one column that
contains data common to all rows in that set.
Col A ColB

Date1 data3
data2
data1
Date2 data5
data4
data6

These rows will not stay together when sorted by date.

You must enter the date on each row and sort by that column

Date1 data3
Date1 data2
Date1 data1
Date2 data5
Date2 data4
Date2 data6

To fill in the blank dates, select column A and F5>Special>Blanks>OK

In active blank cell enter an = sign then point to the cell above and CTRL +
ENTER to fill down.

Copy>Paste Special(in place)>Values>OK>Esc to get rid of formulas.

Gord Dibben MS Excel MVP

>I am putting a correspondence review in a big project. There are 7 columns:
>Date, Form, From, To, Re:, Comments, Pages. Information in some of the
>columns contain multiple lines. What I want to do is, I want to put the
>information in and finally sort them according to dates. How do I group all
>information for a specific correspondence so that when I sort all information
>will be attached to the date. Thank you.

Reply to this Message