How to make a new table by copying the necessary rows from the finished table?

Question

excel

You need to make a new table, copy from the finished table the rows where Israel is.

next, you need to replace the phone prefix. Perhaps this item can be done with formulas? provided that there will be several prefixes.

ps at least with the first point please help.

Answer 1

> You need to make a new table, copy from the finished table s line, where there is Israel.
If manually, then turn on the filter on the "Data" tab, filter the necessary columns according to the rules and copy the filtered where necessary.