Cut and paste only visible cells in filtered area

[ashish514]

I have a data of a large no. of rows with 5 columns. The last 2 columns are district and state. As it is an imported data, in some rows the data has shifted a column, i.e. the name of state is being shown in district column and name of district is being shown in the column to its left. I tried filtering the data such that it shows only those rows where names of the states are coming under district columns and then selecting the whole thing, cutting it and pasting it to the rightmost column. But to my horror, even the correct district entries got pasted under state column. Thanks to undo, the further damage was controlled, but the original problem remains. Now i will have to cut and paste each row or only consecutive rows, until someone gives me a faster solution.

Please help

 

[Andrew Poulsom]

You can't cut a noncontiguous range. Use copy/paste and clear contents instead.

 

[ashish514]

copy/paste doesn't work. It shows the message: That command cannot be used on multiple selections