When you want to apply a small tweak to the document, it must not require much time to Split columns deed. Such a simple activity does not have to require additional training or running through handbooks to learn it. With the right document editing instrument, you will not take more time than is needed for such a swift change. Use DocHub to streamline your editing process regardless if you are an experienced user or if it is your first time using a web-based editor service. This instrument will require minutes or so to learn how to Split columns deed. The only thing required to get more productive with editing is a DocHub profile.
A plain document editor like DocHub can help you optimize the time you need to devote to document editing no matter your prior knowledge about such resources. Make an account now and enhance your efficiency immediately with DocHub!
hello people on youtube thanks for tuning in and welcome back to another video in todays video id like to talk about an interesting power query technique which is where you can split the columns by a delimiter and the number of columns that get generated are variable or dynamic now if you have used the split by feature in power query im sure you know that the number of columns that get generated after you split by a delimiter are fixed and they are not really dynamic they are not really variable ill show you a simple m technique well just write some simple m code to make the number of columns dynamic all right no further ado i hope that sounds interesting lets go all right people im in this excel file and which is where i have a ridiculously simple data just two rows the first row is reheat hes my son and this is me chandeep and we have got our hobbies in the next column so my son likes to play cry and hulk anything to do with hulk my son is a big fan of hulk so hulking become