A Power Query step that combines two or more tables by placing their rows one after another, lining columns up by name and putting null where a column is absent. The plain option modifies the current query, whereas the 'as new' option produces a separate query and leaves the originals alone.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Append queries in context, with comparison tables and the common traps.