Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2012, 11:53 AM
mag mag is offline How to merge multiple records into one and update the cells Windows 7 64bit How to merge multiple records into one and update the cells Office 2010 64bit
Novice
How to merge multiple records into one and update the cells
 
Join Date: Oct 2012
Posts: 11
mag is on a distinguished road
Question How to merge multiple records into one and update the cells

I have a huge excel spreadsheet with about 10,000 records.
It looks somewhat like this:



Last First JDE SAP Oracle WMS HR
Smith John Y Y
SMITH JOHN Y
Smith JOHN Y

Basically i want top merge all 3 records into one and update the cells also to look like
Last First JDE SAP Oracle WMS HR
Smith John Y Y Y Y

Please tell me how can I do this.

Also I tried using "=proper" statement to change names into sentence case (e.g. JOHN changed to John), but I get a #ref error.
Why?

I need a solution asap...plz.

Any input is greatly appreciated!
Reply With Quote
  #2  
Old 10-30-2012, 01:11 AM
Wries Wries is offline How to merge multiple records into one and update the cells Windows XP How to merge multiple records into one and update the cells Office 2007
Advanced Beginner
 
Join Date: Jun 2009
Posts: 40
Wries is on a distinguished road
Default

hi Mag,
I have been looking into this, but so far I have no luck with merging the records.
As for the sentence case, you can use the formula as per the example in the attached image.

Regarding the merging, it will require someone more experienced (otherwise it can take ages for me to make it )
The following link gives an idea:
http://www.pcreview.co.uk/forums/vlo...-t3734350.html

I will try again in evening if I am able to help you further.

Kind regards,
Wries
Attached Images
File Type: jpg proper case.JPG (22.8 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007-How to merge multiple records into one mag Excel Programming 1 11-21-2012 12:11 AM
Need To Compare Two Worksheets, Update Current Records And Insert New David92595 Excel 1 07-20-2012 07:00 AM
How to merge multiple records into one and update the cells Multiple mail merge records on the same page allenglishboy Mail Merge 3 07-18-2012 06:22 AM
How to merge multiple records into one and update the cells Concatenate/merge contents of multiple cells PSYloco Excel 2 05-14-2011 03:46 PM
Help with consolidating multiple records into one wbiggs2 Excel 0 11-30-2006 01:02 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:37 AM.


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