Sep 19 2019 12:13 PM
Get & Transform is an amazing feature in new Excel version, but I am not able to figure it out neither find information online into how to get the result of the transformation in NOT tabular format as in the legacy version.
Sep 19 2019 01:10 PM
@chande333 Sorry, that's Power Query's default behavior. You can go to Table Design > Convert to Range once the load process is done, although that will delete your underlying query.