locked
Need to consolidate cells in Excels RRS feed

  • Question

  • 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