MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Merge data from 2 spreadsheets

  Asked By: Rabiah    Date: Aug 14    Category: MS Office    Views: 1737

I have 2 spreadsheets where the common denominator is "application
title" column...one has info for some of the apps, such as owner
info, the other has rows for other apps, such as features.

Can I merge these into a single sheet based on correlating values in
a certain column?

I want a single sheet with combined data.



2 Answers Found

Answer #1    Answered By: Burke Martin     Answered On: Aug 14

How are you intending to merge  the data? I think I would just perform a
copy/paste command to append to the end of your list.

I am not sure I understand the complexity of your question. Do you want
to maintain two sets of labels?

Answer #2    Answered By: Rolando Reed     Answered On: Aug 14

If you want to pick-up certain field from two tables, you might be
better off jumping into Access, importing the two tables separately,
creating a query that links the application name and then selects
field from both tables based  on your desired final table.

You could then run the query and copy the data  back into Excel (if it
is a one time thing, otherwise you may want to link Excel). I know
this is at a high level - if you are not familiar with Access and
need more detail, let me know.

Didn't find what you were looking for? Find more on Merge data from 2 spreadsheets Or get search suggestion and latest updates.