Grouping Similar items

Hi, I need some advice on a worksheet i have.
Here is what it is. Example

Name Email Area
J.Doe [email protected] WASH
J.Doe [email protected] NY
M.Pesy [email protected] VA
J.Doe [email protected] MX

Each of the abov is in each row and column.I have like 800 ppl like that in the sheet with multipe names attached to diff areas.
Now i want to have a macro that can group all those similar names and put it under one name like J.Doe and all the areas associated with it.Is this workable.
I could do it manually,belive me i tried and its a lengthy process.
Advice>?

About 30 seconds to do that with a Pivot table.

Assuming you have a header on each column, Select all your data and do data
/ PivotTable and Pivotchart report, then hit Next / Next / Finish.

Drag Name into ROW fields and then drag Area BETWEEN the ROW field and the
DATA field.

Done.


Another option for a nice table of data:-

Drag Name into ROW fields and then drag Area into COLUMN field. Now also
drag Area into DATA field.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------




"crosswire123" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi, I need some advice on a worksheet i have.
> Here is what it is. Example
>
> Name Email Area
> J.Doe [email protected] WASH
> J.Doe [email protected] NY
> M.Pesy [email protected] VA
> J.Doe [email protected] MX
>
> Each of the abov is in each row and column.I have like 800 ppl like
> that in the sheet with multipe names attached to diff areas.
> Now i want to have a macro that can group all those similar names and
> put it under one name like J.Doe and all the areas associated with
> it.Is this workable.
> I could do it manually,belive me i tried and its a lengthy process.
> Advice>?
>
>
> --
> crosswire123
> ------------------------------------------------------------------------
> crosswire123's Profile:
> http://www.excelforum.com/member.php...o&userid=33051
> View this thread: http://www.excelforum.com/showthread...hreadid=528665
>

Thank you.It worked beautifully.
im surprised they didn't teach us this at Univ lol
thanks once again

You're very welcome. The Pivot table is probably the single most powerful
feature that excel has (Yet can be so simple to use), and is certainly worth
getting to grips with.

Regards
Ken..................

"crosswire123" <[email protected]>
wrote in message
news:[email protected]...
>
> Thank you.It worked beautifully.
> im surprised they didn't teach us this at Univ lol
> thanks once again
>
>
> --
> crosswire123
> ------------------------------------------------------------------------
> crosswire123's Profile:
> http://www.excelforum.com/member.php...o&userid=33051
> View this thread: http://www.excelforum.com/showthread...hreadid=528665
>