Get & Transform: how to Load into excel not in table format

Copper Contributor

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.

1 Reply

@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.