 So, in this video you will see how we can edit the rows inside the query editor. So, in the last video you have seen about the basic introduction of query editor and you have go through on the query editor. So, here we will see two options first for the keep rows and second for the remove rows. So, in the keep rows we will see five options. First for the keep top rows, keep bottom rows, keep range of rows, keep duplicate rows, keep error rows and inside the remove rows you will again see the five options. First for the remove top rows, remove bottom rows, remove range of rows, then remove duplicate rows, then remove error rows. So, you will see these options, let's move to power by desktop and here as we seen in the last video we have loaded these three files inside the query editor. So, here as we can see the first file that is Australia, so first row and second row is not the correct as we are expecting. So, these two is a dummy rows for us, so we just want to remove these two rows. So, for that we will have an option for remove top rows. So, before going to remove top rows, here go to on home ribbon and reduce rows. Here we have keep rows and remove rows. Inside the keep rows we are having five options as I told you and in the remove rows again we are having five options. So, we just want to remove top two rows, so for that we can use remove top rows, we can select two and click on OK. So, here as we can see top two rows has been removed and in the applied steps we can see we are having this removed top rows and if we did any mistake then we can directly cancel this and our last step and data will be stored as last step we did. So, here we just want to remove top two rows, so we can again remove top rows and two. Now looks good after that here we can see the first row that is not the data row it should be the header. So, for that here we are having four options use first row as header or go to on transform ribbon and here we are having this option use first row as header, so we can click on this and in the applied step it is added two steps first for the promote headers and second for the change type. So, in the Power BI latest version we will see these options for change type automatically. So it will detect the data type of the columns automatically and this step will be added. So just cancel this we will do in the later. After that again we can see we are having these blank rows. So these are not the correct as we want. So we just want to remove these blank rows. So how we can do this? So for that go to on home ribbon, go to on remove rows here we are having for remove blank rows. So once we remove this then we can see we have removed this data and now we can see we are having this NA over here. So these are not the correct. So we just want to remove these NAs from the table. So how we can do this? So go to on remove rows. If we remove the error then it will not be work because these are not the error rows just do it and we will see. So step is added but NAs here because these are the string values like character values for NA. So these are not the errors. So just remove it we can filter those rows which are not required for us. So for that we can use NA and just unselect this and click on OK. So we will see we have removed the NAs but I would not recommend to use the search option for the filtering rows because if anything is having like NA like any character which is containing NA that will also be unselected. Here we are having the integer values that is why I have used it and it is working fine but if you will have any string values and that may have the NA in the other characters so that will be unselected. So I would suggest don't use this search for filtering the rows. Now it looks good and we made a great progress. After that just move to on UK and here again we just want to remove these two top rows so go to on remove rows, remove top rows and to now click on OK. So top rows is removed here we just want to promote the header as the first row. So we can use this option so this is promoted and this step is added so we just want to cancel it. And here again we can see we are having these blank rows so we just want to remove these blank rows so go to on remove rows, remove blank rows. So now it looks good and we made a great progress. Now go to on US and inside the US again we just want to remove top two rows. So here we can select two now click on OK. After that we just want to promote the header and extra step is added so we just want to cancel this. So after that we just want to remove these NA so again we can use the search option for us but I would not recommend to use it if we are having the character data type for the column. Now click on OK that looks good and we have edited the rows so what we have learned in this video we have learned how we can remove the rows and in the keep rows if we want to use the keep top rows so go to on keep top rows we just want to keep top 10 rows so we can select and here we can set the number of rows as 10 now click on OK. So here we are having only top 10 rows other rows are removed so we don't want to use it and in the keep bottom row so data will be in this table from the bottom and we can select the number so how many rows you want after that keep range of rows so here first row and number of row so we just want to start from 2 and we want only 2 rows so it will start from 2 and we will have only 2 rows so this is for range of rows after that we can keep duplicates it will keep the duplicate values only after that keep error if we will have any error rows in the table so it will keep only those so this is for the editing rows so I hope you have understand how we can edit the rows so in the next video we will see how we can append these 3 tables because our output should be a single table so in the next video we will see how we can get the single table so thank you so much for watching this video see you there thank you.