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.
\n \;
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.
\n \;
This live\, one-hour program will introduce you to Power Query&rsquo\;s capabilities\, and show \;you how to use it in several common situations.
\n
\nDiscussion and examples will cover:
* What Power Query is and where to find it in Excel\;
\n\n* The kinds of data sources Power Query can work with\;
\n\n* How to plan and build a query\;
\n\n* How to connect a data source to Power Query\;
\n\n* Using Power Query to parse data such as first and last name and elements of an address\;
\n\n* Transposing rows and columns\;
\n\n* Combining tables\; and
\n\n* Different ways Power Query can output its results.
\n\nThere will be plenty of time for questions\, so please come prepared.
\n\n\;
\n\nPresenter: Gerald Rosenthal\, ComputerImages.com
\n