When you need to apply a minor tweak to the document, it should not take long to Spread out columns record. This sort of simple action does not have to require additional education or running through guides to understand it. With the right document editing resource, you will not spend more time than is needed for such a swift edit. Use DocHub to simplify your editing process regardless if you are an experienced user or if it’s the first time making use of an online editor service. This instrument will take minutes to figure out how to Spread out columns record. The only thing required to get more productive with editing is actually a DocHub profile.
A simple document editor like DocHub will help you optimize the amount of time you need to spend on document editing irrespective of your prior experience with such tools. Create an account now and boost your productivity instantly with DocHub!
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