Document editing comes as a part of many occupations and careers, which is the reason tools for it must be accessible and unambiguous in terms of their use. A sophisticated online editor can spare you plenty of headaches and save a substantial amount of time if you need to Extend columns record.
DocHub is an excellent example of a tool you can grasp very quickly with all the important features at hand. You can start editing immediately after creating an account. The user-friendly interface of the editor will enable you to locate and make use of any feature right away. Feel the difference with the DocHub editor the moment you open it to Extend columns record.
Being an integral part of workflows, file editing should remain straightforward. Using DocHub, you can quickly find your way around the editor and make the necessary changes to your document without a minute wasted.
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