Junior Member

Posts: 10

Merging cells based on same values

Hi

Below is my requirement

I have cells in a excel in the below format

AAA 12323
AAA 56565
AAA 77789
BBB 12
BBB 13
DDD 142
CCC 121
CCC 13

I need to merge the cell of column A until the value is same . My output should be

12323
AAA 56565
77789

12
BBB 13

DDD 142

CCC 121
13

Please let me know if this can be achieved through some macros or forula

Thanks
Vasanth

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sum the values of cells based on fontcolor	[email protected]	Excel Worksheet Functions	1	March 28th 08 02:51 PM
Merging cells changes values, bug?	Bart op de grote markt	Excel Programming	0	March 29th 07 03:29 PM
conditional formating cells i Excel based on other cells values	Elias Petursson	Excel Worksheet Functions	3	May 23rd 06 06:45 PM
Merging cells with the same values	Iain	Excel Discussion (Misc queries)	0	August 8th 05 06:35 PM
Merging Two Cells and Keeping the Values	Raymond	Excel Discussion (Misc queries)	10	May 30th 05 08:05 PM

All times are GMT +1. The time now is 11:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us