#1
|
|||
|
|||
How to merge matching cells vertically?
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? |
#2
|
|||
|
|||
Hi
By using Text to columns and concatination u can do. |
Tags |
cell, merge |
|
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 |