How to use Merge Two Tables for Excel

Please add the ability to search the lookup table with wildcards

I install a trial download but it wasn't work with my MS 365. I would like to buy ULTIMATE SUITE FOR EXCEL.
I need to ensure it could be work and I will purchase order. Can you feedback & what I should do.

PS

No use, as soon as the add in was installed, my trial was over and none of the tools were usable.
Maybe include a free trial period before expecting users to pay...

Hi,

i cant figure it out why this doesnt work.

I have a productfeed with 12.000 products, all have stock.
Also i have a stockfeed which contains 300.000 items.

All products have an unique SKU, the productfeed contains all unique SKU's.
I want it to update the stock. The stockfeed is updated every 1 hour, so i want to do the following:

1. CSV file with products is named productfeed.csv.
2. CSV file with stock is name stock.csv

I want to transfer the stock in stock.csv to productfeed.csv, but should match the stock with the SKU.
Do you understand what i mean? Can you please help?

I use the merge table function to update data from one file to another. Why do I continue to get addition (identical rows) being added to the new spreadsheet? The files have exactly the same headers (with the exception of three additional columns. My data matches correctly with the headers, and I unselect the one row that I want to be updated.

Hi, I use the free trial and when i want to merge 2 tables, it skip step 4 & 5, it doesn't let me to add column to main table? please advice.

Hi
Quick Question
Is there any way to save a previously used "Merge Two Tables" process so the next time it is needed I do not need to set it up again?
Thanks
Max

Can it automatically merge and combine two cells when one of the sheet cell value is added?

Hello,

I hope that you could be able to answer my question. Well I have this 2 different sheets and I wanted to merge them but the biggest puzzle are:
1. both Sheets have product IDs
2. The first sheet contains complete details like prices, roi etc. but does not have SKU
3. The 2nd sheet have only ID and SKU
4. Now my client wants to look up price values from the 1st file using IDs and put it under the second file, my problem is I am using a Vlookup and already searched for possible ways to do this, I cannot find a unique Identifier that could pull these records accurately since both of these files contains duplicate values of IDs and does contains different prices
5. It is working on my Vlookup query however on the duplicate records, it only returns the first value results.
6. What I want is to return unique price value of each Duplicate ID inline with the id row while retaining the order of the 2nd file. Because some of the solutions I found is to lookup the result chronologically.

I hope that you could help me. Thanks in advance.

Hi!
What if I want to use the "merge two table" feature on a daily basis, is there a way to simplify the process, e.g. via a macro or such?

I am using the Merge Two Tables wizard and recently, I've had issues on step 3. When selecting my main column and trying to select the column from the Lookup table columns, they are all blacked out. I can tell each of them are listed, but they are not readable so I am unable to differentiate which I should choose. I've tried closing out, putting all the information I'm looking up in the same workbook, etc. But nothing is working.

Does your tool perform a vlookup on multiple rows with the same matching value? I tried the Merge Table feature, and it only reported the first instance/row. However, I have other rows that have the same matching value that I'm trying to add all together in the final result. Thank you.

Hi Abhijeet,
I am trying to Merge two worksheet using this add-on but it is showing an error message as follows.

'' The add-in can't add new records because it encounters Excel limit for the total number of rows in a sheet'
Thank you for using the Merge Two Tables tool! Please note that our products don't impose any additional limitations, so the number of rows and columns in the resulting table is defined by the version of Excel you have. Here you can find the limits for rows and columns.
If the number of rows in your sheet does not exceed the limit, please contact our support team at support@ablebits.com. Please attach your book and describe the Merge Two Tables steps you take in detail, mention all the options you tick in the wizard.I need some row according to implements column I put row selected numerical.

i don't seem to be able to get insert additional matching rows to work. I've tried both ways and both times they update the main table row data - I was expecting that it would add a row of new data with a status of matching or add a row of new data right after the matching row with a status of matching so I could compare the data in the fields I'm updating. I have 75k records in the main table and 27k in the lookup with 101 matches - I want to compare the names and company values for the 101 while adding the remaining 26,899 records to the main table with the names and company data in the correct fields for importing my records (the adding the new records (as new row) is working correctly and as expected.

I thought I had this problem solved but is doing it again. It goes from step 3 directly to step 6. I don't get the option to select the columns I want updated in the main table or pick the columns I want added to the main table. I'm doing all the work within a spreadsheet that has 6 tabs. I'm using Excel 2010.

Please Help,

Thanks

Never Mind.
Please ignore my previous e-mail claiming that Steps 4 and 5 were not being executed. I closed all sessions of XCEL, restarted the process and it worked just fine.

A.Casas

I decided to take the 7 Day Trial offer for the Merge Table Wizard. However, it only worked the first time. Thereafter, it skips steps 4 of 6 and 5 of 6. I wanted to test with it some more before I buy it. Please advise.

Thanks,

A. Casas

Hello,

I am trying to Merge two worksheet using this add-on but it is showing an error message as follows.

'' The add-in can't add new records because it encounter Excel limit for the total number of rows in a sheet''

Kindly help me to solve this.
Thank you

Hello, I am using the Merge Two Tables application and I am a trying to get every instance to merge but only the first instance is merging and leaving he rest of the merge fields blank. Please assist me.

I want ONLY the Merge Two Worksheets wizard, but you charge $100 for the entire Ultimate Suite, which I do NOT want. You were offering the Merge Tables tool for $60, what happened to it?

Hi,

My company is interested in buying the product, yet we wanted to solve a doubt first:
Can it combine multiple workbooks with multiple sheets to update a "master" workbook, but giving the option to choose which information we want to preserve? Or do you have another product that could do it?

Thanks.

ACC