Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2011, 09:12 AM
Hilwey Hilwey is offline Formula that can merge multiple rows with the same ID into one row Windows Vista Formula that can merge multiple rows with the same ID into one row Office 2007
Novice
Formula that can merge multiple rows with the same ID into one row
 
Join Date: Aug 2011
Posts: 1
Hilwey is on a distinguished road
Question Formula that can merge multiple rows with the same ID into one row

I have a spreadsheet that looks like this:

Column A Column B
1234 A
1234 B
1234 C
1234 D
5678 A
6785 B




I want the Column A that has the same value to combine Column B into one row to look like this:

Column A Column B Column C Column D Column E
1234 A B C D
5678 A
6785 B

And so on for others that are duplicates...Is this prossible?
Reply With Quote
  #2  
Old 08-23-2011, 12:30 AM
Catalin.B Catalin.B is offline Formula that can merge multiple rows with the same ID into one row Windows Vista Formula that can merge multiple rows with the same ID into one row Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You can use a macro as in sample workbook attached.
maybe this is not the best way to do this, as there are so many ways to do a job, and you have to improve it... (that's your job)
Attached Files
File Type: xlsm copy col to a row, next col.xlsm (21.5 KB, 177 views)
Reply With Quote
  #3  
Old 07-08-2015, 12:43 PM
japie01 japie01 is offline Formula that can merge multiple rows with the same ID into one row Windows 7 64bit Formula that can merge multiple rows with the same ID into one row Office 2007
Novice
 
Join Date: Jul 2015
Posts: 1
japie01 is on a distinguished road
Default

THANKS Catalin !!!!

Tried many macro's and this one worked perfectly for me after minor changes.

Reply With Quote
  #4  
Old 07-08-2015, 08:50 PM
Catalin.B Catalin.B is offline Formula that can merge multiple rows with the same ID into one row Windows Vista Formula that can merge multiple rows with the same ID into one row Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You're wellcome japie01 , thanks for your feedback
Cheers,
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula that can merge multiple rows with the same ID into one row Multiple Mail Merge? imogul Mail Merge 1 06-24-2011 07:20 PM
Formula that can merge multiple rows with the same ID into one row Concatenate/merge contents of multiple cells PSYloco Excel 2 05-14-2011 03:46 PM
Stumped With Mail Merge Formula JennEx Mail Merge 0 05-28-2010 07:44 AM
Formula that can merge multiple rows with the same ID into one row Moving formula range multiple cells when moving sum over one cell FraserKitchell Excel 4 02-26-2010 10:38 AM
Word mail merge and formula mridley Mail Merge 0 04-30-2006 11:26 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft