Move filled cells in Col A to top of data

[Grahamfeeley]

Hi guys I have some cells in col A that needs moving to top of data
cell A is null
B has data
c is null
D has data
and so on so many cells can be empty or filled
I need to move all filled cells to top , including adjacent columns
so i guess it is like a sort on all columns with filled cells in col A on top

Regards
Graham

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[AlphaFrog]

I need to move all filled cells to top , including adjacent columns
so i guess it is like a sort on all columns with filled cells in col A on top

Put this formula in an empty column and copy it down.
=IF(A1<>"",ROW(),"")

Select all your data including this formula column and sort it using the formula column as the criteria. You can clear the formulas after the sort. These steps could be recorded to a macro.

[AlphaFrog]

You're welcome.