While doing so, there are a number of ways to manipulate the data, and one of those will delete blank rows. Get & Transform DataĮxcel's Get & Transform Data feature provides a quick way to retrieve data. You can work with your own data or download the demonstration. None of these tips work in the browser version. The other tips will work in earlier versions of Excel. If you're using an earlier version, run a quick search on Power Query Add-in. The Get & Transform Data tip is available only in Excel 2016. I'm using Excel 2016 (desktop) on a Windows 10 64-bit system. Excel is still a security headache after 30 years because of this one feature.
