On Wednesday, 6 June 2018 12:51:06 UTC+1, Claus Busch wrote:
Hi Andy,

Am Wed, 6 Jun 2018 04:30:48 -0700 (PDT) schrieb Andy McNicol:

Just one thing now and then I am sorted, I am still; getting a 0 between each of numbers./ Thus how do I get rid of this so I only get the cells with the actual values in it. Note that on the original sheet there will be an entry every 5th cell on the row.

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgc5oNtEN1ZcSxHN4NQ


Regards
Claus B.
--
Windows10
Office 2016

Claus,

You are a superstar, thank you very much all is good now. That link explained it all and let me know what I had to do visually.

Thanks again,

Hopefully I can return the favour in the future.

Andy