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.