Merge Rows of Text Data
Hi, I have an Excel file with Text Data in it. The format of the data in the Excel file looks something like this: I want to merge the text in the Document Body Col in a single cell based on the Document Title. For example, instead of having two rows for File Name 1, I want one row for File Name 1 with the Document body concatenated together. This is not possible in Excel due to the character lim...