Question about Microsoft Office Standard for PC

1 Answer

Merging Data in 2 Separate Excel Workbooks

Good Morning All, I need to merge two seperate work books, of average 20 columns width Both do/do not hold matching information. EG: Worksheet A Joe Smith Address1 Address2 City Postcode Work Sheet B Joe Smith City E-mail Telephone What I would like to do is create a single merged workbook which has all the fields merged into a single row - without duplication (obviously, I can backtrack and delete manually if necessary) Thank-you

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Guru:

    An expert who has written 7 tips or uploaded 3 video tips

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Expert
  • 58 Answers

If the First Name and Last name are equal to both work sheets, I will just sort them by First Name and Last name and copy the results into a separate work sheet. If the names are different you will have to use Access: This can be easily done with Access and SQL, just import both work books into different tables to access and use the create query wizard, play with the results until you will get the result you want. Access will also solve the duplicate problem easily. Very important: You will have to use join properties: Read help about join properties and understand how this works... Afterward you can export it back to Excel or use Copy/Paste. If you can't use Access and have only Excel: You will have to use Vlookup on various fields until you will get the result you want. Its a hard work but in the end you will get the same result as access. Let me know what happend Daniel

Posted on Aug 20, 2007

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Merge 2 columns with 550 cells each all at once?


Merging Columns In Excel Now that we've clarified what merging columns actually means, we can explore how to do it. The first step is to perform the merge for the first cells. Let's go back to our first example and suppose that we are merging column A that contains first names with column B that contains second names. We'll put the merged columns into column C. To merge cell A1 with cell B1 we woul type the following into cell C1:=A1&" "&B1


paste this into C1 (or where needed)
=A1&" "&B1

Jun 15, 2010 | Microsoft Office Excel 2007

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

1 Answer

Unable to complete merge process.


Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.

Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will

At what stage are you failing in the merge now?

May 15, 2009 | Microsoft Office Professional 2007 Full...

1 Answer

Merging 2 columns in excel of names example F1592&H1592 IN COLUMN G1592 SUE JONES


You need to go into format cells and then merge them together and you should be just fine. Highlight the cells that you wish to merge and then right click and then click on format cells and then merge cells together.

May 05, 2009 | Computers & Internet

1 Answer

Merging problem


Use the Help function in excel and search for "Consolidate". This will show you how to consolidate data from multiple worksheets into one worksheet.

Feb 19, 2009 | Microsoft Excel for PC

1 Answer

I have a question; How do I seperate address written in one column into 4 column as line1 line 2 citi pincode


Assuming 1) you're using Excel and 2) the addresses are written:

1234 Main St., Anytown, CA 90210

You can use "Text to Columns" feature (selected "Delimited" and check the box next to "comma"). This will split the data into 3 columns (address | city | state and zip). Then run the "Text to Columns" again on the "state and zip" column and use "Fixed width" to separate the state from the zip.

If the assumptions I used are incorrect, clarify and we'll try again.

Jan 06, 2009 | Computers & Internet

1 Answer

Merging data from 2 files into one


QuickBooks data files cannot be merged. This is because of the linkages involved. One solution would be to enter the journal entries manually.
Another option may be to switch to the Enterprise version. You would still have seperate files, but the data from two files can be merged in a report.

Dec 24, 2008 | Intuit QuickBooks Pro 2007 Full Version...

1 Answer

Matching data


1. Open up both workbooks.
2. Copy one worksheet from one workbook to another using.
Right click on the tab of one book and Select "Move or Copy"
3. A dialog box will appear..Next to the "To book" select the workbook you want to move it to.
4. Be sure to select the 'create a copy' box in the bottom left of the dialog box.
5. Sort each worksheet by students name. Data..Sort.
6. Copy the scores from one sheet to another.
7. You then you can manipulate the scores and compare anyway you like by using formulas in different columns.

Apr 29, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

154 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3015 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...