How can I copy values from one column, they are spread down the column, with a lot of empty cells in between, but all cells contain a formula which needs to remain in the cell where the data is copied from. All values should then be copied to the next column, but be compiled and sorted alphabetically and without any empty celles in between. This operation should take place automatically...!
<<Original title: Copy values from one column to next, but compile and remove empty cells.
I changed it to the more descriptive title shown above.
byundt--Excel TA Page Editor>>