So now let's see how you can edit and delete columns and rows.
So as you can see there are a whole bunch of columns up here.
There's definitely you don't want to work with and you want to remove the unwanted columns.
So there are multiple ways by which we can delete these columns.
First of all if you want some of it you don't want it in your data or just simply click on that.
And when you right click on it you'll see the option removed and when you click on it the column will
be removed.
You can say that I like this you can select multiple columns by using shift dabbas shift there as well
along with your mouse.
So like this you can select multiple columns and when you click on the move columns all these columns
will be removed.
Another way of removing columns or selecting column is to these two columns when you click on choose
columns you'll see those columns which are in your column table so that you don't want that.
I don't want these three columns I simply uncheck them and click on OK and I'll just get those required
columns in my table and you can see the step is being shown here.
As we move the other columns which are just removed.
Now suppose I just want to remove rules as you can see this.
First of all having null values which is of no use.
And so I just cannot simply click on the cell or you are deluded.
This is not possible.
So you remove this rule.
I have to click on remove rules then click on remove rules.
So this will ask us how many draws from the top I want removed.
So I'll just simply add one by this the first two will be removed and it will be shown here as well.
So this first vote will be removed like this.
We can remove rose from the bottom as well.
I can do as many rows just by clicking on the number of rows from the bottom I when I remove by clicking
OK the 50 rows from the bottom will be removed just like we can remove alternate rows.
We can remove duplicates.
Suppose there are duplicate values in this particular column and I want to remove the duplicates of
what I do is click on remove duplicate to now.
This will only have the values which are unique.
So I'll just leave it for now and do this that and I suppose there are blank rules as well in your data.
So you can always just simply click on Blanco and you don't have to go and find those blank what you
are.
Just click here and all the blank will be removed.
So just like the suppose in your data you have in this particular column you have multiple values the
same values that you want to keep and remove the unique ones.
So when you click on this you'll find a value like give duplicate.
So when you click on duplicate now all the values which have at least one duplicate value will be shown
here just like this.
Order Number ten thousand one hundred seven.
It has four other duplicate set to duplicate as well.
This will be shown here so everyone will have at least one duplicate will be shown here.
So this way you can only duplicate.
So there are other option as well as like keep out or keep the placates keep range of those by clicking
on the range of those you can just mention and specify how many number of rows within the range you
want to keep.
All I want to keep from.
Rule number two.
Rule number one thousand.
So my rule number two is this.
And once you click on OK so the values between to get hosen will be shown up here.
So by this way you can always really easily edit your rose or remove the values from your rules.
So now suppose in this particular column as you can see the text is done you know in this particular
format and what you really want to do is in the case of the text in the uppercase.
So this is quite easily possible in the editor.
So Cucina do the uppercase all you have to do is click on transform and you will see this format option
when you click on format and simply click on uppercase all the text in this particular column which
you have selected will be converted into uppercase So there are many other things just like in my must
word or most power in all those features like in lowercase capitalize each word claim and prefix and
suffix you can simply add it like those.
So this is another handy feature of added in our values in particular column.
That's all for this we do.
And I join you in the next one.
Thank you.