Hi,
Please help with the below.
I want to concatenate the Values in an array based on a reference cell.
For example if Column A and B have the following values.. I want to concatenate the vlaues of Array B for A1 in cell C1.
In other words from the below list I want to concatenate all the matching fruits in column B tagged to each digit in Column A and this concatenated value to be available in Column C for each reference cell.
For easy reference I have attached a sample file. XLSX
A B C(Desired Result)
1 Apple Apple,Orange,Pine
1 Apple Apple
3 Orange Orange,Peach
4 Pine Pine,Peach
5 Peach Peach
6 Peach Peach
2 Pine Pine
3 Peach Orange,Peach
4 Peach Pine,Peach
1 Orange Pine,Peach
1 Pine Pine,Peach
Bookmarks