Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-863882%22%20slang%3D%22en-US%22%3EGet%20%26amp%3B%20Transform%3A%20how%20to%20Load%20into%20excel%20not%20in%20table%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863882%22%20slang%3D%22en-US%22%3E%3CP%3EGet%20%26amp%3B%20Transform%20is%20an%20amazing%20feature%20in%20new%20Excel%20version%2C%20but%20I%20am%20not%20able%20to%20figure%20it%20out%20neither%20find%20information%20online%20into%20how%20to%20get%20the%20result%20of%20the%20transformation%20in%20NOT%20tabular%20format%20as%20in%20the%20legacy%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-863882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eget%20and%20transform%20data%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-863972%22%20slang%3D%22en-US%22%3ERe%3A%20Get%20%26amp%3B%20Transform%3A%20how%20to%20Load%20into%20excel%20not%20in%20table%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-863972%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F412043%22%20target%3D%22_blank%22%3E%40chande333%3C%2FA%3E%26nbsp%3BSorry%2C%20that's%20Power%20Query's%20default%20behavior.%20You%20can%20go%20to%20Table%20Design%20%26gt%3B%20Convert%20to%20Range%20once%20the%20load%20process%20is%20done%2C%20although%20that%20will%20delete%20your%20underlying%20query.%3C%2FP%3E%3C%2FLINGO-BODY%3E
chande333
Occasional Visitor

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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies