Microsoft Office Forums - View Single Post - How to merge matching cells vertically?

Thread: How to merge matching cells vertically?

View Single Post

Old

12-22-2009, 01:21 AM

Odiseh

Odiseh is offline

Odiseh uses Windows XP

Windows XP Odiseh uses Office 2007

Odiseh uses Office 2007

Office 2007

Novice

The original poster

Join Date: Dec 2009

Posts: 1

Odiseh is on a distinguished road

Default

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?

Reply With Quote