Combine Two Tables Together?

Apr 1, 2013

I have:

- Table 1 has ~1,600 records (name of game, meta score, user score)
- Table 2 has ~3,000 records (name of game, genre, publisher)

I want:

- Table X has ~1,600 records (name of game, meta score, user score, genre, publisher)

Basically, I want to take the genre and publish columns from Table 2, and add it to Table 1. However, I want to ignore the extra ~1,400 games that Table 2 has.

I'm nearly a complete noob when it comes to excel. Noob to the point where I don't even know what this thing is called, so I don't even know how to search for it properly! I know something can be done since there is a common column between the two (name of game).

Edit: Also, I think it'd be easier if I were able to attach my excel spreadsheets but I don't even know how to do that

View 1 Replies


ADVERTISEMENT

Combine And Sort Two Tables

Dec 1, 2009

I'm analyzing and charting performance data from two different boats. I am attempting find a way to combine the two charts into a single chart that is sorted by MPH as per my manually sorted example.

View 9 Replies View Related

Combine Tables From Different Worksheets In One Table

Jul 18, 2012

I have an excel workbook with 11 different worksheets. Each worksheet represents a project my company is working on. And in each worksheet there is exactly the same table, just with different data).

Now we would like to get an overview of all these different data put together in one 'summarizing' table on a new worksheet (number 12).

-Is it possible make such a table without having to copy past all the time?
-The data in the tables may change over time, so it would be good if that 'summarizing' table automatically adapts to the other ones.

View 9 Replies View Related

Combine Tables Deleting Duplicates

Aug 28, 2009

way to join two or more tables in excel adding new rows and columns.

In this way:

Input TABLE1
ID, Tag1, Tag2
1, alfa, big
2, delta, small

Input TABLE2
ID, Tag1, Tag3
2, delta, green
3, gamma, yellow

Output RESULTING TABLE
ID, Tag1, Tag2, Tag3
1, alfa, big, -
2, delta, small, green
3, gamma, -, yellow

View 9 Replies View Related

Combine Rows From Matching Certain Criteria In Two Tables

Jun 9, 2013

I have a spreadsheet that contains two input tables: Parallel and Perpendicular. Next, the user can select a group which a certain entry belongs to. Now what I want is a "summary" of these entries in a table that has no blank rows and combines both Parallel and Perpendicular entries by the Group. Please note that there is no fixed number of inputs for any one group i-e the solution has to be dynamic.The groups are numbered from 1 to 6 and number of groups is fixed i-e 6.

A sample file illustrating the inputs and required output is attached.

I also posted this on: [URL] ....

Sample_file_summary.xlsx

View 2 Replies View Related

Nest / Combine 2 Sumproduct Functions From 2 Different Tables

Aug 20, 2014

Looking to nest or combine the following 2 functions because I'm looking up the same cell content, except within 2 different tables.

=IF(B12="","",SUMPRODUCT(--($B$12:$B$17=X18),--($S$12:$S$17))) and =IF(B22="","",SUMPRODUCT(--($B$22:$B$32=X18),--($S$22:$S$32)))

Right now, these functions works well from a single table but need to combine them. Other function examples are welecomed too.

View 6 Replies View Related

Combine Multiple Pivot Tables On One Report?

Apr 21, 2014

I have to track how well location managers are keeping track of skill competencies.

We rate skills as...
0 – know nothing ,
1 – read training manual,
2 – check off by manager.

I need the managers to provide these ratings then I have to report what locations need more training. When an new employee is entered into the system, the manager should give them a target of 2 for each skill the employee needs to gain. If the target skill is 2 rating higher than the current skill level, I have a column named Delta that records a 2.

I have learned how to use the pivot table feature. I can make separate pivot tables using filters that show…
a) how many 2s each employee has for a target,
b) how many 2s each employee has for deltas,
a) how many 2s each employee has for a current level and I can show the date the 2s where achieved

What I need is to learn how to combine all of this information on one pivot table (or report), but the filters really seem to make a mess of it all when it is all together. adding multiple sheets to one Pivot table.

Screenshots...
Count of Targets
Count of Deltas=2
Count of Current Skills
!What I need to produce!

[Code].....

View 1 Replies View Related

Combine Rows From Two Tables In Certain Order And Matching Certain Criteria

Jun 9, 2013

I have a spreadsheet that contains two input tables: Parallel and Perpendicular. Next, the user can select a group (from a drop down) which a certain entry belongs to. Now what I want is a "summary" of these entries in a table that has no blank rows and combines both Parallel and Perpendicular entries by the Group. There is no fixed number of inputs for any one group i-e the solution has to be dynamic.

Attached is a file illustrating the inputs and the required output. I would prefer a formula based approach but not against VBA based suggestions either.

Sample_file_summary.xlsx

Also posted at: [URL] ....

View 2 Replies View Related

Combine Data From Multiple Worksheets - Pivot Tables

Sep 20, 2009

I am trying to combine sorted data from 2 worksheets to a new work sheet to process further. I have one worksheet with order number, part number, order qty but with different delivery dates. On another worksheet, I have the order number too, part number, the qty delivered. The qty delivered is not always the same each delivery.

My aim is to find out how many are already delivered under a certain purchase order and the balance of undelivered parts.

I used pivot tables to sort out the data but I am stuck here not knowing how to extra the sorted data from the pivot tables to the 3rd worksheet. I will need to match the order number and the part number.

View 9 Replies View Related

Combine Two Tables Which Change In Rows Depending On Input Of User Using VBA In Excel?

Apr 13, 2014

i have a macro which takes the results generated and puts them into a table and filters the data so that zeros does not show and arranges the table from largest to smallest. Now i have a problem where i need to select the power, fuel oil consumption, weight and area from one table and the other power, fuel oil consumption, weight and area from the other table and combine them together so that i can have all possible combinations of the data, but i don't want the zeros to show in the combinations. i need the combined data to show on a separate sheet. The data of table 1 varies with rows as shown:

The Data of Table 2 varies with rows as shown:

I would like to achieve a result like this in the following columns and rows without having to input them manually:

View 1 Replies View Related

Excel 2010 :: Creating Multiple Tables In VBA And Referring To Newly Created Tables?

Jul 1, 2013

Using Excel 2010. I'm writing a macro that sets up a workbook to be used for estimating at the beginning of a project. In the code I need to create multiple tables (formerly known as "lists") in the workbook. Then later in the code I need to refer back to those newly created tables. Currently, the code that creates the table is part of a loop that creates the table on many different worksheets. The problem of course, is that I have to name the Table, and then it won't create a table of the same name on the next sheet. Then, later in the code, I need to make adjustments to the table that was just created before looping to the next sheet.

Is there a way to create a table without giving it a constant name? Or by giving it a name that builds off of other info in the sheet? For example, I would be good with the naming the table after the sheet name: "Sheet1_Table" or such.

Code:
Sub Auto_Open()
'
Dim sht As Worksheet
If Range("A1") = 1 Then

[Code].....

View 2 Replies View Related

Looking Up 2 Different Tables To Merge?

Feb 19, 2014

I am trying to merge two different databases in the next week. The problem I am running into is the name from 1 database isn't always the same on the other database.

I want to merge Database 1 with Database 2 and create a relationship with them both by using the database 2 internal #. As you can see in my table database 1 has similar names to database 2 but they are not exact. I want to match these names and have the formula on match tell me what the database 2 internal # is. I have also uploaded a sample excel doc with a note in B2.

database1
Herb Chambers Ford of Braintree
Herb Chambers Honda of Seekonk
Dimmitt St. Petersburg
Database 2 matched internal #
Database 2
Herb Chambers Ford of Braintree (Dave Dinger Ford)
Herb Chambers Honda Of Seekonk (7-FI)
Dew Cadillac (Dimmitt of St. Petersburg)
Database 2 internal #
15360
15301
25413

View 2 Replies View Related

Comparing Two Tables

Jun 10, 2008

I have one .xls file that contains an inventory list of all the products that I want.

Unfortunately this .xls file does not contain the prices for these items. I have another .xls file that contains SKU numbers and the prices related to those SKU numbers.

Is there a way to run every single SKU in the first file against the second file and, when a match is found, take the entry in the price column of the second file and place it in the first file so that my first .xls file contains all my products with prices?

I included sample data.

View 12 Replies View Related

Sumproduct Across Tables

Feb 22, 2010

I think this requires SUMPRODUCT, but can't work it out.

The attached spreadsheet should explain clearly.

View 14 Replies View Related

Lookup In Sub-tables

Aug 7, 2008

I have a table with dates that have bonuses associated with them, some times the bonues change, so i have another table with the date the bonus is effective and then the range of bonuses based on the sales of the month....

View 12 Replies View Related

Corresponding Tables To Find A Value?

Aug 22, 2013

i am trying to correspond 3 columns like:

Code:
________________________________________________________________________
points from / points to / note defined / points pupil got / his note
------------------------------------------------------------------------------------------------------------------------------
0 10 4 33 #
11 20 3 16 #
21 30 2 25 #
31 40 1 07 #
-------------------------------------------------------------------------------------------------------------------------------

Column 5 (his note) must be calculated looking at value on column 4 (points pupil got) and finding it on the intervals given by columns 1 and 2 (points from/to), and finally ascribing the value from column 3 (note defined).

View 2 Replies View Related

Filtering Tables With VBA

Dec 11, 2013

I have a worksheet with data in named tables on several sheets. Each of these tables has a column called "filter" (this is not always the same column number between sheets). The values in this column are either 0 or 1, depending on if that particular row is relevant under the book's current selections.

I'm trying to figure out the code that will take a table and filter it to show only the rows which have a 1 under the "filter" column.

View 2 Replies View Related

Sorting From One To More Tables?

Jun 8, 2014

Need to sort data from one table to other tables in diferent worksheets so I can easy print report.

for example: (i got about 40 markets to add in table, this 5 is just for e.g.)

ABCDEFGHIJ1DATEMARKETEMPTY B.FULL B.E.B. - F.B.NETOPRICEM1M2M3215.6.2014market 11500145050145004260900062000011000315.6.2014market 21600160001600042672000670000-2000415.6.2014market

[Code].....

View 9 Replies View Related

Validation Tables

Jun 14, 2007

I have validation tables in a few cells. I've unlocked them and password protected the sheet so that they couldn't be changed other than what is in the list.

What's happening is that the list is there, but the cell is also allowing an entry that is not in the drop down.

How can I protect the cell to only allow the validation list?

View 9 Replies View Related

Hide Tables Using VBA

Jun 12, 2008

I am after some code that will hide tables based on whether they contain certain values.

If we take the following example: ....

View 9 Replies View Related

Formula From 2 Different Tables

May 9, 2006

i entered an item (ie, Aircard5740, cost = $99.99). This specific item must be compared from the 1st table (type of phone) with 7 different columns where does it fall the same. Once found, another item will be entered, (ie, America's Choice 450, cost = $59.99) and again will be compared to the 2nd table (commission) with 7 different columns, (while still based from the 1st item), and from this 2nd table, there's the commission amount be taken. what formula can i type to get the commission from the 2nd table?

View 2 Replies View Related

Merging To Different Tables Into One

May 17, 2006

I have 2 tables in excel that i need to merge into one, Table 1 has 10 colmns and Table 2 has 7. Both tables have as column 1 a heading of Material, this is the column i need to compare as table 1 does not contain a material description field, but table 2 does, the bold headings are the key ones, but other column information is required. I have attached a sample ss to show what i am trying to do.

Table 1 Col Headings
Material
MTyp
MS
R
Clt
L/O
Created on
Created by

View 2 Replies View Related

Create Tables From XML With CSS

Jun 1, 2006

how to create tables from XML with CSS.Below are the codes....

<?xml version="1.0"?>
<?xml-stylesheet type="text/css" href="feedrecipe.css"?>

<recipe_summary>

< percentages>Percentages</percentages>

<percentages>
<eggshells_heading>Eggshells</eggshells_heading>
<eggshells>5%</eggshells>
<wheat_heading>Wheat</wheat_heading>
<wheat>60%</wheat>
<sunflower_heading>Sunflower Seeds</sunflower_heading>
<sunflower>5%</sunflower>
<meat_heading>Meat and Bone Meal</meat_heading>
<meat>10%</meat>..................................

View 4 Replies View Related

Lookup From Tables

Jul 5, 2006

I am currently constructing a spreadsheet with an engineering application. There are standard size shafts that bearings must fit on. Once the design is run, i obtain a number which is usually inbetween the two standard sizes. I need the spreadsheet to select the larger one. for example, 184 must be looked up from

160
180
200
220

I need it to select 200, however and the moment using lookup function i am getting 180.

View 4 Replies View Related

Vlookup With 2 Different Tables

Sep 7, 2006

i'm building a spreadsheet where there is a list where users will input work shifts (those shift can be, for example, "M", "N", "T", "Me", "Ne", "Te"). i use two different columns to retrieve (using vlookup) values for M, N, T and Me, Ne, Te shifts. those values are in two different tables (one table for M, N, T shifts and another one for Me, Ne, Te)

for the M, N, T shifts column i use:
VLOOKUP(A1;$values.$A$1:$D$3;IF(WEEKDAY(G3)=1;4;IF(WEEKDAY(G3)=7;3;2)))

for the Me, Ne, Te shifts column i have:
IF(ISNA(VLOOKUP(A1;$values.$A$67:$D$69;IF(WEEKDAY(G3)=1;4;IF(WEEKDAY(G3)=7;3;2));0));0;VLOOKUP(A1;$values.$A$67:$D$69;IF(WEEKDAY(G3)=1;4;IF(WEEKDAY(G3)=7;3;2));0))

this seems to works fine, but only for one shift per day. the problem is that workers may work more than one shift per day. is there a simple way of, in one column, vlooking up the values for every M, N, T shift, every day ignoring any Me, Ne, Te and the opposite in the other column?

View 5 Replies View Related

Copying Multiple Tables Into One?

Oct 15, 2013

Say I have 10 tables and want to copy them into one single table. Easy right? Just copy / paste.

The restraint with copy paste is, if I make an adjustment to one of the 10 tables, it will not be reflected in the master table. I would have to recopy the table every time I make a change.

I was wondering if this there was such a function that says: "Once done copying with X table, start copying Y table, and so forth."

View 3 Replies View Related

VLookup Two Tables In Spreadsheet

Jan 18, 2014

I have a spreadsheet with two tables in it. Table 1 contains some data consisting of two columns both populated with data (where 1 = a, 2 = b, 3 = c and so on) and table 2 consists of two columns one column contains data and initially (numbers) column two is blank. Now I need a VLOOKUP that will look at the second column (red letters in the example) in table one, and where the same value (number) appears in table 2 populate the corresponding letter.
I do not wish to use filters as the table is extremely large. I have attached an example

View 4 Replies View Related

Break The Link Between Tables?

Apr 28, 2014

I copied a worksheet with a pivot table as a new worksheet. I wanted to group each pivot table differently on each worksheet, but the changes I make on one worksheet is reflected on the other. Is there a way to break the "link" between these tables?

View 2 Replies View Related

How To Reference Tables On Another Sheet

May 11, 2014

How do you reference a table on another sheet so that when you sort that original table it doesn't change the reference you made on that other sheet.

i know how to do this when i am referencing a cell. for instance if i am referencing a cell on sheet 5 and that comes out to something like =Sheet5!B2, i know that when i sort the data differently in sheet 5, that reference will know to change to =Sheet5!B18 or where ever that original reference ends up in this new sorting. but if I do =Table5[2] or something, and i sort that table differently, the reference will change to the new data in that cell and will not follow old reference through the new sort.

View 1 Replies View Related

One Spreadsheet Two Tables - Sync

Jun 24, 2014

Sync these two tables? the firs one is connected to a master sheet so when that master sheet is updated by entereing data, inserting rows or deleting them so is the table, the second table was created to hardcode data manually so it doesn't feed from the master. My problem is that if a row is inserted in the first table, the second table doesn't update that change. Is there any way to connect both?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved