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
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
217 Replies