Use the CONCATENATE function to put data from multiple columns together in a new one Using the concatenate formula in ...

Excel offers several methods to tackle ... for performing multiple column lookups. It works by combining values from multiple columns into a single lookup key using a unique spacer character ...