I made a comment on the video, but since its from a few years back I was searching for a better place to ask the question. Hopefully I found it The question is in regards to this video: https://www.youtube.com/watch?v=a7E29H5ZUmE
I'm having an issue that just arose and I'm hoping you'll be able to help me out. I've been using this method for a few weeks and everything has been working fine. Starting today, when I get to the step where we remove all columns except NoHeader then expand the remaining data to our finished result, PowerQuery is "randomizing" my order of columns for some reason. Before today, this has been working great and keeping all my columns/rows in the order they should be. I haven't changed anything and are still following your steps to a T. Have you ran across this issue before? If so, what's the fix? Thanks for your help ahead of time and keep the great vids coming!
TL:DR - At the final expand after removing headers, PowerQuery is changing the order of my columns for some reason. How do you prevent this?
I'm having an issue that just arose and I'm hoping you'll be able to help me out. I've been using this method for a few weeks and everything has been working fine. Starting today, when I get to the step where we remove all columns except NoHeader then expand the remaining data to our finished result, PowerQuery is "randomizing" my order of columns for some reason. Before today, this has been working great and keeping all my columns/rows in the order they should be. I haven't changed anything and are still following your steps to a T. Have you ran across this issue before? If so, what's the fix? Thanks for your help ahead of time and keep the great vids coming!
TL:DR - At the final expand after removing headers, PowerQuery is changing the order of my columns for some reason. How do you prevent this?