how to make excel 2016 for mac work with data query to web

Make Excel 2016 Work With Data Query To Web Update At Once

Please note that our second table contains 26 rows compared to only 10 rows in the first table.

If you decide to do it manually, you may spend hours only to find out that youve messed up important information.

If you are an experienced Excel pro, then you can possibly rely on VLOOKUP and INDEX MATCH formulas.

A macro, you believe, could do the job in no time, if only you knew how.

In earlier versions, some windows may look different from the images in this tutorial that were captured in Excel 2016.

Also, the common columns should contain only unique values, with no repeats.

Please note that our tables have different numbers of rows, and although table 1 has duplicates in the Seller column, table 3 contains only unique entries.

Also, although we say tables, you do not actually need to create an Excel table.

Your tables could be usual ranges or named ranges as in this example.

This additional column does not have any values yet, just the word Table in all the cells.

But dont feel discouraged, you did everything right, and we are going to fix that in a moment.

To complete the merging process, perform the following steps within the Power Query Editor.

In this example, we select only the Product column because our first table already has Seller and Order ID.

I will outline the steps briefly here, because you have already done all this when joining the first two tables.

You can rename this connection if you want (right-click and select Rename in the pop-up menu).

After these improvements, my combined table looks very nice.

But there is nothing that would prevent you from selecting two or more column pairs.

It is important that you click on the columns in the same order in both previews, so the matching columns have the same numbers.

For example, Seller is key column 1 and Product is key column 2.

Blank cells or rows that Power Query is unable to match show null.

When you make some changes to a source table, you dont have to repeat the whole process again.

Make Excel 2016 Work With Data Query To Web Update At Once

Simply, click the Refresh button on the Queries Connections pane, and the merged table will update at once.

I have just added a few more rows to the second table to show you more capabilities of our add-in.

How To Make Excel 2016 For Mac Work With Data Query To Web