Combining data from two different tables into one

[tampa123]

Team,
Need some assistance. I'm looking to consolidate two tables into one without duplicating the exact same information. I've posted an example with the desired result below. Please let me know if this is possible and if you have any questions.
[TABLE="width: 218"]
<tbody>[TR]
[TD]Table 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC Company[/TD]
[TD="align: right"]$70,000 [/TD]
[/TR]
[TR]
[TD]DEF Company[/TD]
[TD="align: right"]$80,000 [/TD]
[/TR]
[TR]
[TD]XYZ Company[/TD]
[TD="align: right"]$1,000,000 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Table 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC Company[/TD]
[TD="align: right"]$70,000 [/TD]
[/TR]
[TR]
[TD]GHI Company[/TD]
[TD="align: right"]$120,000 [/TD]
[/TR]
[TR]
[TD]JKL Company[/TD]
[TD="align: right"]$65,000 [/TD]
[/TR]
[TR]
[TD]XYZ Company[/TD]
[TD="align: right"]$1,000,000 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Combined Table[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC Company[/TD]
[TD="align: right"]$70,000 [/TD]
[/TR]
[TR]
[TD]XYZ Company[/TD]
[TD="align: right"]$1,000,000 [/TD]
[/TR]
[TR]
[TD]DEF Company[/TD]
[TD="align: right"]$80,000 [/TD]
[/TR]
[TR]
[TD]GHI Company[/TD]
[TD="align: right"]$120,000 [/TD]
[/TR]
[TR]
[TD]JKL Company[/TD]
[TD="align: right"]$65,000 [/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[hissonrr]

There are a lot of ways you could do this... but if I am understanding your problem right it would just be that if you copy and paste it it would create a lot of duplicate data row...

The easiest way to fix this is short and sweet.

1. select and copy all the data in one of the tables (doesn't matter which one)
2. Right click on the other table that you did not select the data from and and select "Insert rows above/below"
a. this will basically combine the two tables together and you can delete the one you selected from.
3. go to your data toolbar and select the tool that says "remove duplicates"
4. you can then select the column that has the duplicate rows of data and remove them (this removes the entire row based on if there are duplicates of anything)

Does this work for what you need?

 

[tampa123]

There are a lot of ways you could do this... but if I am understanding your problem right it would just be that if you copy and paste it it would create a lot of duplicate data row...

The easiest way to fix this is short and sweet.

1. select and copy all the data in one of the tables (doesn't matter which one)
2. Right click on the other table that you did not select the data from and and select "Insert rows above/below"
a. this will basically combine the two tables together and you can delete the one you selected from.
3. go to your data toolbar and select the tool that says "remove duplicates"
4. you can then select the column that has the duplicate rows of data and remove them (this removes the entire row based on if there are duplicates of anything)

Does this work for what you need?

Thanks hissonrr. This helps and was actually my workaround, but I didn't know if there was a way to combine vlookup, ifthen, etc formulas to automate the process?