combining different size tables
Hi ronm,
Your answer to Carlo is the format that I interpretted that you wanted and
my previous reply should do that. However, if you want to automate it, I can
do that too. However, would you like to test what I have posted and if it
returns what you want then reply and I'll automate the process with a macro
for you. I won't use vlookup if doing it in a macro but knowing that the
format is correct is a good start.
Also, do you need instructions to install a macro?
Regards,
OssieMac
"ronm" wrote:
Hi Carlo,
Actually, just the opposite - I want the final table to be all 44k rows from
the first table but where there is a match of IDs, I would have the 2nd table
row appended to the first.
table 1 xxxxxxxx
table 2 yyyyyyyy
final xxxxxxxx
xxxxxxxxyyyyyyyy
xxxxxxxx
I need to do this once a month and would like to automate it.
ronm
"Carlo" wrote:
Hey ronm
just that I understand it correctly;
The table you have in the end starts with the columns of table 2 and then
with the columns of table 1.
Do you need to do that once, or is it a recurring process?
Carlo
"ronm" wrote:
I have two tables of different length - table 1 has 44K rows by 8 columns,
table 2 has 180 rows by 8 columns. The first column in each table is a
unique ID such that all 180 IDs are part of the first table.
I want to run a process that looks at each row in table 2, compares the ID
to the rows in table 1, and if a match is found, it appends the row from
table 2 to the corresponding row in table 1.
I would end up with one consolidate table where 180 rows would have all 16
columns.
Is there a simple way to do this? Thanks for any help.
|