Excel Magic Trick 1243

DESCRIPTION

Transform GDP Data Set: Power Query 2nd Method or Advanced Filter?
Learn how to Take Large Data Set with Country Economic Data for the years 1970 to 2013 and use one of two methods: Power Query (From Bill Szysz) or Advanced Filter (From Bill Mr Excel Jelen)
(00:08) Problem explanation
(01:10) Power Query Example, including “Drill Down” to show text values as CSV, and editing Contains Filter to have function look at Drill Down Table and Column in Table. This amazing example is from Bill Szysz.
(06:05) Advanced Filter Example, including using the extract area Field Names as part of the Filter. This amazing example is from Bill Mr Excel Jelen.
(10:20) Vote in comment area for Advanced Filter or Power Query

WORKBOOKS