Forum Discussion
Solved
Adding Partial rows to a column for many many entries
Hi there, Lets Assume I have a column (1,2,3,4,5,6,7,8,9) and another column (5,3,2,gap,1,21,4,gap,5,6,82) - they are both have 9 entries, just one of them has gaps. How do I automatically insert the...
Is this what you are looking for? The result column is E and the column without gaps is A. I made a test for 1000 entries in column A and it seems to work. Click on the button in cell G2 to start the macro.
Is this what you are looking for? The result column is E and the column without gaps is A. I made a test for 1000 entries in column A and it seems to work. Click on the button in cell G2 to start the macro.