I have a column in Excel with a number of values below each other, with empty rows in between. I would like to automatically create a new column on a new page where all these values will be lined up, without the empty rows in between.
Is there a way (formula) to do this?
To illustrate, I have attached a file of how I would like it.
Hope you have an idea to make this happen!
Thank you in advance
Giel
Bookmarks