Filter Lists

Skybluekid

Well-known Member
Joined
Apr 17, 2012
Messages
829
Hi All,

I have a list of over 2000 rows of data, in columns A-G. In 648 rows of data, the contents which should be in Column D are in Column E, and the contents which should be in Column E are in Column F and so on. Is there a easy way to move these items back to the original columns, without doing them one by one?
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

francoisdublin

New Member
Joined
Jan 23, 2014
Messages
32
Can you not filter on the rows (presumably, if you filter on column D for blanks, you will see rows which have no data) and then select all the blanks in Column D and press CTRL and minus (-) to delete blanks; you can then move cells left when prompted.
 

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,069
Office Version
  1. 2013
Platform
  1. Windows
SkyBlue,

Similar but I don't think you can use filter.
Assuming blanks in D then.

Try Select Col D Find/Select Goto Special Blanks ok

Right click on the active cell in D right click Delete Shift Left Ok

Hope that helps.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,335
Messages
5,595,569
Members
413,996
Latest member
mabelO

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top