You may try the OUTLINE function...
For details visit
http://office.microsoft.com/en-us/ex...033&mode=print

The way you want the data is not a good solution if you have 4-5 or more
rows for one lawyer...

"Nydia" wrote:

I am working with a spreadsheet that keeps track of payment sent to
certain a attorneys. The report is then distributed. Some attorneys are
paid for several matters, so they have several rows. What I would like to do
if possible is group eliminate the redundance of attorney names. Is there a
way to group them.

Ex.
Attroney Type Subject 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr YTD YTD%
ABC KL Litigatiion 100 250 450 450
1250
ABC KL Handbook 100 100 100 100 400
CDE BL Litigation 100 100 100 100
400

Is ther a way to group it so that is show like this:

ABC KL Litigation 100 250 450 450 1250
Handbook 100 100 100 100
400
CDE BL Litigation 100 100 100 100
400