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

CONCAT and TEXTJOIN were added to Excel in 2019, so if you're using an older version, you might not have access to these functions. Both combine text from multiple cells into one. According to ...