Rename Initial Confirmation with airSlate SignNow

Rename initial confirmation

[Music] hello and welcome to exceed learning in this video we're going to show you how you can dynamically change the first and column names of the table that looks similar to this so as we can see we have two rows and the column names appear in both of them and this is this is an issue that we had from our client he had an expert from his system and the system exported data in a way that the months were properly added as a first row of the table but then he had this deterministic column names appearing one row below so we had to make it dynamic because uh depending on the export there there were a dynamic number of columns that could appear prior to this names of the months so basically you can you could have like a type column here and we needed to somehow dynamically address all those newly added columns we created a solution using list zip function and now we're going to show you how you can achieve the same functionality first and by the way we're going to learn quite a bit about the i would say advanced encoding so first what we need to do we need to push the data into power query so let's go to data from table range this could also be any you could also invoke this query from any other excel table but for the purposes of this video we're going to use the same the same table or the same excel for the query now the data is inside of power query what we can see is that all these values from jam to december are properly added as column headers but the issue is that these column names or these row values should become the column names and this should happen dynamically actually what we don't want to achieve is that this column renames itself to content this column renames itself to country and this to segment second okay if we segment sorry okay so what we actually want to achieve is this part of the code if we remove everything except this syntax in curly brackets we can see that this is actually a nested list of lists so this object contains three this is a list object containing three lists and each of these lists has an old name and the new name nested inside of that list so we need to get to this kind of an object but make it a dynamic one now we will duplicate this query and let's start from the source step the first thing we need to do we need to somehow dynamically get the address from until which we want to uh let's say we want to promote these raw values into column values and for that purpose we will use an anchor and we will use this text text of gen as an anchor text to get the position...