When you want to apply a small tweak to the document, it must not take long to Choose columns voucher. This kind of basic activity does not have to demand extra education or running through handbooks to learn it. With the right document editing resource, you will not take more time than is necessary for such a swift edit. Use DocHub to simplify your editing process regardless if you are an experienced user or if it is the first time making use of an online editor service. This instrument will take minutes to learn to Choose columns voucher. The sole thing required to get more effective with editing is a DocHub account.
A plain document editor like DocHub can help you optimize the time you need to spend on document editing no matter your previous knowledge about this kind of instruments. Create an account now and increase your efficiency instantly with DocHub!
hey everyone its John here and in this video were going to take a look at how we can use the choose columns command in power query to make selecting columns and performing operations on those columns a little bit easier when we have a wide set of data so here Ive got data loaded into the power query editor and you can see that its pretty wide set of contact data and each record has five different contacts in it so for example here Ive got email one and if I scroll over then you can see that Ive got email two and lets say I wanted to combine those so merge those columns together what I might normally do is select the first one hold ctrl and scroll over to the next one and then try and find it and select Pat and repeat until Ive got them all selected and then I can come up to my transform tab and merge those columns now Im just gonna cancel that so an easier way to do that is to come up to the Home tab and theres an option here choose columns and if you click on that we have t