Combining rows with duplicate names - sum numeric, concatenate str

  • Follow


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. 

0
Reply Utf 3/2/2010 10:21:01 PM


0 Replies
333 Views

(page loaded in 4.079 seconds)

Similiar Articles:
















7/28/2012 1:13:52 AM


Reply: