Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-21-2016, 02:59 AM
Willem113 Willem113 is offline Merge duplicate rows but retain data from one column Windows XP Merge duplicate rows but retain data from one column Office 2010 64bit
Novice
Merge duplicate rows but retain data from one column
 
Join Date: Sep 2016
Posts: 1
Willem113 is on a distinguished road
Question Merge duplicate rows but retain data from one column

Good morning,



I am having a problem.

I really want to merge duplicate rows in an large Excelfile, butt from the rows that are merged the textdata, which differ, have to be retained in the same merged row. (SEE ATTACHED EXAMPLE )

Hope you can help me with this! (sorry for my English)

Kind regards,

Willem
Attached Images
File Type: jpg Naamloos.jpg2.jpg (69.9 KB, 15 views)
Reply With Quote
  #2  
Old 09-21-2016, 05:42 PM
macropod's Avatar
macropod macropod is offline Merge duplicate rows but retain data from one column Windows 7 64bit Merge duplicate rows but retain data from one column Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your data depict the types as being in column A, with the clubs & cities in columns D & E, leaving columns B & C available. What happens if a club has more than 3 types?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge duplicate rows but retain data from one column Macro for Column to Rows Data brunssl2 Excel Programming 3 04-28-2014 07:07 AM
Mail Merge a letter to headmasters with rows of data/students assoc. w/school sgaeta Mail Merge 7 04-10-2014 06:34 AM
Merge duplicate rows but retain data from one column Macro to Delete Duplicate Rows and Retain Unique Value expert4knowledge Excel Programming 1 02-17-2014 08:02 PM
Merge duplicate rows but retain data from one column mail merge using data from column A as placeholder. keys Mail Merge 2 10-31-2013 01:55 AM
Merge duplicate rows but retain data from one column How to send several rows of data from one column to each recipient in one go mikustykus Mail Merge 14 09-30-2013 08:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:43 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