Hi. I need help with writting a formula. I have a table with 2 or 3 columns. In the first column i have the same number in some cells,but i don't know for sure which cells. In the second and third column i have data that is different in each cell but is connected with the same number from the first column. What i need is a function or formula that can help me with putting all data from each cell from second and third column, in a row connected with one from the same numbers.
Example: Colum A B C 1) 1 yellow 2) 4 .... 3) 1 pink 4) 7 ..... 5) 9 ..... 6) 1 green
Solution that i need: Colum A B C D 1) 1 yellow pink green