I have a column and I want to strip out the empty columns and only populte with the columns that have a value in them

           A
1      Tom
2
3
4      Jane
5
6
7      Tim
8
9      Jack

             B
1        Tom
2        Jane
3        Tim
4        Jack

I want to strip out the spaces in Column A and place the data in Column B together as shown
Any help would be apreciated thank you.

By doing a simple sort, you can force the empty cells to the bottom of the sort range. Tie it in with a copy & paste to column B.

Run a delete query with the condition "Is Null" assuming that what you mean by spaces are empty fields and not actually spaces where someone has pressed the space bar. If so, modify your condition to look for spaces.

Oops! Sorry, wrong Forum. Thought it was Access!