Excel 2016’s Get-&-Transform for importing and cleansing Data

Can an Excel file be both the source and destination of imported data via Get & Transform? It sure can.

Here I make up for a mistake I made in front of God & e’rbody on ExcelTV. The challenge:

The data looks like a report broken down by State. We want Rep data. So, without writing a single formula, Excel 2016’s Get & Transform feature allows us to reshape the data so that a pivot table is possible.

BTW: Check out the full ExcelTV interview here

It was much fun being back on the air with Rick Jordan and Szilvia.