Power Query/Get&Transform

%3CLINGO-SUB%20id%3D%22lingo-sub-483923%22%20slang%3D%22en-US%22%3EPower%20Query%2FGet%26amp%3BTransform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-483923%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20gone%20through%20the%20steps%20to%20link%20data%20from%20Doc%20A%20to%20Doc%20B.%20What%20I%20really%20want%20to%20do%20is%20sort%20that%20data%20in%20different%20ways.%20Can%20I%20do%20the%20sorting%20on%20different%20sheets%20and%20still%20be%20able%20to%20refresh%20in%20Doc%20B%20if%20I%20make%20changes%20to%20Doc%20A%3F%20Or%20do%20I%20have%20to%20keep%20the%20data%20on%20one%20sheet%20in%20Doc%20B%20in%20order%20to%20refresh%3F%3C%2FP%3E%3CP%3EAlso%2C%20If%20I%20make%20changes%20in%20Doc%20B%20like%20page%20breaks%20or%20formatting%2C%20will%20it%20still%20refresh%20any%20changes%20made%20in%20Doc%20A%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIts%20been%20a%20while%20since%20I've%20used%20Excel%2C%20so%20I'm%20real%20rusty.%20Thanks%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-483923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-488381%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%2FGet%26amp%3BTransform%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-488381%22%20slang%3D%22en-US%22%3ESo%20if%20you've%20used%20power%20query%20to%20pull%20information%20from%20one%20file%20(Doc%20A)%20into%20a%20second%20file%20(Doc%20B)%20then%20you%20can%20use%20Power%20Query%20to%20change%20it%20to%20your%20preferred%20sort%20order.%20It%20doesn't%20matter%20how%20the%20data%20is%20sorted%20on%20Doc%20A%3CBR%20%2F%3E%3CBR%20%2F%3EFormatting%20changes%20to%20Doc%20A%20will%20not%20impact%20things%20in%20Doc%20B%2C%20however%20adding%20new%20columns%20or%20inserting%20new%20rows%20may%20impact%20your%20results%20(but%20these%20can%20be%20fixed%20by%20editing%20Power%20Query)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have gone through the steps to link data from Doc A to Doc B. What I really want to do is sort that data in different ways. Can I do the sorting on different sheets and still be able to refresh in Doc B if I make changes to Doc A? Or do I have to keep the data on one sheet in Doc B in order to refresh?

Also, If I make changes in Doc B like page breaks or formatting, will it still refresh any changes made in Doc A?  

Its been a while since I've used Excel, so I'm real rusty. Thanks for your help!

1 Reply
Highlighted
So if you've used power query to pull information from one file (Doc A) into a second file (Doc B) then you can use Power Query to change it to your preferred sort order. It doesn't matter how the data is sorted on Doc A

Formatting changes to Doc A will not impact things in Doc B, however adding new columns or inserting new rows may impact your results (but these can be fixed by editing Power Query)