How to merge matching cells vertically?

Odiseh · #1 12-22-2009, 01:21 AM

hi suppose we have a worksheet like this:

apple 50 Jack

apple 20 Tim
Apple 10 Mary
Orange 40 Jim
=====

I wanna to turn the worksheet like this:

50 jack
apple 20 Tim
10 Mary
Orange 40 Jim

Is there any way?

iam4urk · #2 01-02-2010, 02:41 PM

Hi
By using Text to columns and concatination u can do.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display the cells which add up to a certain sum	edbyford	Excel	1	11-26-2009 01:30 PM
Need cells to autofill with color	Silver Rain 007	Excel	1	10-22-2009 08:19 PM
How to stop correcting zeroes in cells ?	kevin_ms	Excel	4	09-14-2008 10:08 PM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM
Nested if formulat to merge cells	cristi22	Excel	0	10-23-2006 08:28 AM