Excel 2013 Power Query 09

Merge Multiple Worksheets in Workbook To New Table using Append Feature

DESCRIPTION

See how to Merge Multiple Worksheets in Workbook To New Table using Append Feature:
(00:08) Problem Setup
(00:39) Table Feature for getting Tables into Power Query
(00:53) Use “From Table” feature in Power Query to get Tables into Power Query
(00:59) Keyboard Differences in Power Query between Excel 2010 and Excel 2013
(02:13) Discussion of Keyboard Shortcuts as a “Dance”
(02:33) Merge Multiple Sheets in Workbook To New Table using “Append Feature”
(03:51) Bug in Power Query November 2014 Update: Number Format not being picked up when Query is refreshed.

WORKBOOKS




Be the first to comment

Leave a Reply