I have about 14,000 lines of data, each row contains only one cell of data, but the data can be in various columns such as A1, D2, E3, C4, A5, F6, etc.
I am trying to move all the values to the left so that all the data is in the far left column. Is there a way to delete all the blank cells before the data and move the data to the left (all to column A)? I am using XL 2003 and Windows XP.
Thanks!
I am trying to move all the values to the left so that all the data is in the far left column. Is there a way to delete all the blank cells before the data and move the data to the left (all to column A)? I am using XL 2003 and Windows XP.
Thanks!