Hi There,
In what situations would using combining worksheets versus appending queries be used and what benefits are there using one as apposed to the other method?
Thank you in advance,
Karen
Hi Karen,
The options are merging and appending under the 'Combine' group.
Append is effectively copying and pasting one query under another, excluding the headers. The columns must be the same in each query, otherwise they are added as new columns.
Merging allows you to bring data from one query into another using a join. You don't have to bring in all of the columns and it will result in new columns added with the matching data aligned to the rows based on the columns you specify as a match. It's a bit tricky to explain in detail but watching the merge video should provide more detail.
There are lots of different join types to suit various scenarios. Append on the other hand is much more limited in that it simply adds the data on new rows under the first query.
Hope that helps, but I'm here if you have more questions.
Mynda
