Help required!!!!!
Hi there,
I am a new user of excel working with a small table consisting of 4 columns & 4 raws; some of the cells are empty in the table (as shown below). I would like to move the data into the last column (far right hand side). is there any way to automatically move the data.
So far I have tried this_
Highlight data and move cursor to the boundary of the cell and pick - drag - drop
Highlight data and select Alighning tool that only moves numbers in right/centre/left within their specific cell
Many other things I have tried that I forgot didn't work -- below is an example of what I am trying to acheive.
Type/format of data I have
1--------2--------3--------4
5-----------------6---------2
----------5------------------
4------------------8--------
......and this is what I aiming for (moving raws till it reaches the last colum)
1--------2--------3--------4
5-----------------6---------2
-----------------------------5
----------4------------------8
Help will be very much appreciated!!! Thanks
Bookmarks