Forum Discussion
Get & Transform: how to Load into excel not in table format
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.
