#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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 |
|
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 |
Multiple mail merge records on the same page | allenglishboy | Mail Merge | 3 | 07-18-2012 06:22 AM |
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 |