I have data imported into Excel. The data is arranged with a row detailing a product heading, followed immediatly by rows with product data, followed by a blank row separating the data from the next next product header, rows of data etc.
I there way I can segregate, for example all products ending with the letter S together with the data rows for that product, and delete all others.
I there way I can segregate, for example all products ending with the letter S together with the data rows for that product, and delete all others.