Assume a simple two column dataset with Name in column A and Department in column B. There are repetitions in the Name column. Here’s a snapshot of the base data:
One may want to merge data from multiple cells into a single cell – basically a view where all unique names are listed in a column and all departments for each name appear in a single cell (separated by commas). The expected result should look like this:
You may view my solution in this workbook.
You may also watch a short video of my solution here
To accomplish the reverse of this i.e. start at Table 2, process the dataset and arrive at Table1, you may refer to my solution at this link.
Merge data from multiple cells into a single cell
{ 10 Comments }