If you want to apply a minor tweak to the document, it must not take long to Expand columns record. This kind of simple activity does not have to demand extra training or running through guides to learn it. With the appropriate document editing tool, you will not spend more time than is needed for such a quick change. Use DocHub to streamline your editing process regardless if you are an experienced user or if it’s your first time making use of a web-based editor service. This instrument will take minutes to figure out how to Expand columns record. The sole thing required to get more effective with editing is actually a DocHub profile.
A plain document editor like DocHub can help you optimize the amount of time you need to devote to document editing no matter your previous experience with such instruments. Create an account now and enhance your productivity instantly with DocHub!
whats up guys Parker here I have a very useful video today showing you how you can expand record columns dynamically in power query I say dynamically because if youve ever expanded a record in power query before you probably went through the UI which hard codes column names so this video is going to teach you how you can create make it dynamic so youre not specifying column names to expand instead it will expand all of the columns that are returned in your data so in this example Im using a sample API call that returns some null values and some record values so you see out of the eleven records here three have values in them so if you have expanded columns in the past you probably went through the UI by clicking these little two arrows and it specifies all the columns that you have available so we can click OK and this is how it normally expands so youll get all of the different columns you see that there are no values for those records that had no records but the but the rows th