the way you need it - columns need to be split, tables combined, or certain entries omitted. Doing it by hand is typically impossible for all but the smallest data sets.
 

Power Query is an oft-overlooked feature of Excel that can automate many such conversions, for example by separating city state and ZIP code in an address, or transposing rows and columns.
 

This live, one-hour program will introduce you to Power Query’s capabilities, and show you how to use it in several common situations.

Discussion and examples will cover:

* What Power Query is and where to find it in Excel;

* The kinds of data sources Power Query can work with;

* How to plan and build a query;

* How to connect a data source to Power Query;

* Using Power Query to parse data such as first and last name and elements of an address;

* Transposing rows and columns;

* Combining tables; and

* Different ways Power Query can output its results.

There will be plenty of time for questions, so please come prepared.

Presenter: Gerald Rosenthal, ComputerImages.com