Hello....I'm hoping someone can help me with this:
I need to concatenate data from several fields in the same column, based on the value in a separate column. The number of fields are not the same. I have a ws that looks like:
Column A Column B
10 Red
10 Yellow
12 Car
12 Truck
12 Boat
3 Apple
3 Lemon
3 Banana
3 Peach
After the concatenation I need the following:
Column A Column B
10 Red,Yellow
12 Car,Truck,Boat
3 Apple,Lemon,Banana,Peach
Is this possible? Any help would be greatly appreciated.
Thanks,
Klyoldham
I need to concatenate data from several fields in the same column, based on the value in a separate column. The number of fields are not the same. I have a ws that looks like:
Column A Column B
10 Red
10 Yellow
12 Car
12 Truck
12 Boat
3 Apple
3 Lemon
3 Banana
3 Peach
After the concatenation I need the following:
Column A Column B
10 Red,Yellow
12 Car,Truck,Boat
3 Apple,Lemon,Banana,Peach
Is this possible? Any help would be greatly appreciated.
Thanks,
Klyoldham