Need to consolidate cells in Excels

• Question

• 

  

  0

  Sign in to vote

  I have the following on on an excel spreadsheet:

  fname  lname age height color Style

  Greg Roy 45 511 White 23

  Greg Roy 45 511 56

  Greg Roy 45 511 White 72

  Eric  Blair  34 62 Green 10

  Kim Schetei 34 411 Green 32

  Kim Schetei 34 411 Pink 45

  But I would to convert it in the format below:

  fname  lname age height color Style

  Greg Roy 45 511 White,white 23,56,72

  Eric  Blair  34 62 Green 10

  Kim Schetei 34 411 Ping,Green 32,45

  not sure I should just use the if statement within the cells or just use the VBA scripting. Thanks.

  Wednesday, July 16, 2014 1:16 AM