Given a data set like this:
5 10
5 7
5 13
7 5
7 13
10 13
10 5
13 7
13 10
13 5
How can I format the data into something like the following?
5 10,7,13
7 5,13
10 13,5
13 7,10,5
The commas could be spaces, or the numbers could be spread out among the columns.
What I need to do is remove all duplicate entries in column 1, while pasting all of their corresponding column two values into a single row. Is there a function that does this, or a relatively easy way to program it? I appreciate any help with this.
Bookmarks