Thanks everyone,

I've used the solution provided by Ursul as it appeared to work best with what data I had

Thanks again