When you want to apply a minor tweak to the document, it must not take long to Choose columns contract. Such a basic action does not have to demand extra training or running through manuals to understand it. With the appropriate document modifying instrument, you will not take more time than is needed for such a swift change. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it is your first time making use of a web-based editor service. This instrument will require minutes or so to learn to Choose columns contract. The only thing required to get more productive with editing is a DocHub profile.
A plain document editor like DocHub will help you optimize the time you need to dedicate to document modifying regardless of your previous knowledge of this kind of instruments. Make an account now and improve your productivity immediately 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