Document editing comes as a part of many professions and jobs, which is the reason tools for it must be available and unambiguous in terms of their use. A sophisticated online editor can spare you plenty of headaches and save a substantial amount of time if you have to Finish columns record.
DocHub is an excellent example of a tool you can grasp very quickly with all the valuable features accessible. Start modifying instantly after creating your account. The user-friendly interface of the editor will enable you to discover and make use of any feature in no time. Notice the difference using the DocHub editor the moment you open it to Finish columns record.
Being an integral part of workflows, file editing must remain easy. Using DocHub, you can quickly find your way around the editor and make the necessary modifications to your document without a minute lost.
in this video we want to see how to take a column of records and convert it into a proper data set now last video 1716 we saw how to do it with an excel worksheet formula in this video we want to see how to do it with power query using the user interface and then a second way using m code [Music] well just say that these power query tips are your morning cup of coffee now that cool intro came from our teammate gert and the second power query m code trick that well learn comes from brian xyz and addisojo from the comments at youtube its great hanging out on our awesome online excel team now when do you use power query rather than a formula well if your data is external and you need to import it anyway thats a great time to use power query now we have the same column of data in a text file so well go up to data import from text and this text file and the excel file can be downloaded in the link below the video im going to double click theres a preview were going to click transfo