Hello,
I have this table with data. If the numbers match then consolidate the data in the row into one cell dividing the values with a comma.
<tbody>
</tbody>
I am open to use a function or UDF.
I thought of combining two functions =VLOOKUP() and =CONCATENATE()
Here are some near solutions that I found but they consolidate the column data and not the row data.
http://www.get-digital-help.<wbr>com/2010/12/20/excel-udf-<wbr>lookup-and-return-multiple-<wbr>values-concatenated-into-one-<wbr>cell/
http://www.ozgrid.com/forum/<wbr>showthread.php?t=94895&p=<wbr>445111#post445111
http://www.ozgrid.com/forum/<wbr>showthread.php?t=25239&p=<wbr>128076#post128076
I have this table with data. If the numbers match then consolidate the data in the row into one cell dividing the values with a comma.
Number | Data 1 | Data 2 | Data 3 | | Number | Result |
1 | a | b | c | 5 | b | |
2 | | | c | 8 | a | |
3 | a | b | | 2 | c | |
4 | a | | c | 7 | | |
5 | | b | | 4 | a, c | |
6 | | b | c | 1 | a, b, c | |
7 | | | | 6 | b, c | |
8 | a | | | 3 | a, b |
<tbody>
</tbody>
I am open to use a function or UDF.
I thought of combining two functions =VLOOKUP() and =CONCATENATE()
Here are some near solutions that I found but they consolidate the column data and not the row data.
http://www.get-digital-help.<wbr>com/2010/12/20/excel-udf-<wbr>lookup-and-return-multiple-<wbr>values-concatenated-into-one-<wbr>cell/
http://www.ozgrid.com/forum/<wbr>showthread.php?t=94895&p=<wbr>445111#post445111
http://www.ozgrid.com/forum/<wbr>showthread.php?t=25239&p=<wbr>128076#post128076