Combining rows with duplicate names - sum numeric, concatenate str

D

Dina

Hi I have data that contains a mix of numeric and text fields and rows with
duplicate names. I would like to combine rows with duplicate names into one
row. Here is the example of my data:

Name | Company | City | #ofaccounts | commission
---------------------------------------------------------------------
Jon Smith | CompX | NY | 5 | 500
Jon Smith | CompY | Toronto | 10 | 3000
Jon Smith | CompY | LA | 15 | 1000
Jane Doe | CompZ | Detroit | 25 | 2000
Jane Doe | CompZ | Detroit | 35 | 500

To get:

Name|Company|Company2|Company3|City|City2|City 3|#ofaccounts|commission
-----------------------------------------------------------------------------------------------
Jon Smith|ComX|CompY|CompY|NY|Toronto|LA|30|4500
Jane Doe|CompZ|CompZ|blank|Detroit|Detroit|blank|60|2500

The maximum number of duplicates by name is 5.

Can this be done without using Macros? If yes, I would prefer a method as
such.

Thank you very much in advance.
 
Top