Hi All,
I need to amalgamate some data I've got but my minds gone completely blank. The name is all one person but I need all the types to come into one Cell. I'd normally use concatenate but some people haven't had all the tests so the data isn't consistent. Some have only had 2 parts..I...