Hi everyone,
Just wondering if anyone can give me a hand with a list I am working on, basically I have a list of products however there are rows which contain no data. What I want to do is move this into a consecutive list on another sheet without the blank rows.
For instance there is a product in A6 but then there aren't any products until cell A12, so on my second sheet I want the products for these to list in cells A3 and A4.
This is a dynamic list and will change often.
Thanks everyone.
Just wondering if anyone can give me a hand with a list I am working on, basically I have a list of products however there are rows which contain no data. What I want to do is move this into a consecutive list on another sheet without the blank rows.
For instance there is a product in A6 but then there aren't any products until cell A12, so on my second sheet I want the products for these to list in cells A3 and A4.
This is a dynamic list and will change often.
Thanks everyone.