When you want to apply a minor tweak to the document, it should not take long to Split table record. This type of basic action does not have to demand extra training or running through guides to understand it. With the appropriate document modifying instrument, you will not spend more time than is needed for such a quick edit. Use DocHub to simplify your modifying process regardless if you are an experienced user or if it’s your first time making use of an online editor service. This instrument will take minutes to figure out how to Split table record. The sole thing required to get more effective with editing is a DocHub profile.
A simple document editor like DocHub will help you optimize the time you need to spend on document modifying regardless of your previous knowledge of such instruments. Make an account now and improve your productivity instantly with DocHub!
[Music] hi in this video Im going to show you how to split data into columns or rows and this is gonna be using power query so maybe for example weve got data here this is a two column table and weve got data here that is in one column cell here and its separated by line breaks and we want to break it out into something like this into almost a proper table but this is probably something you see familiar with data thats seen that separates into dates months quarters etc years and originally it comes this format and you want to kind of break it out now this is separating it by columns now if we wanted to separate something data by rows maybe we have something example like this we also have maybe something coming out of some kind of source system and the data in one cell or one column is all just all separated by line breaks or commas or whatever and we want to get into proper table format where we have our item in serial number we have items here with number here you can see that w