Hi there,
I got a table with lots of names in column A and numbers in column B. Now I would like to turn this information into two columns, where all names of column A are written next to each other, if they have the same number in column B.
Example
a 1
b 1
c 1
d 2
e 2
f 2
should end up as:
a b
a c
b c
d e
d f
e f
(the same number for a name means there is an interaction between the names - I want all interactions in the final two columns)
Any help to get this in a macro would be appreciated.
cheers
I got a table with lots of names in column A and numbers in column B. Now I would like to turn this information into two columns, where all names of column A are written next to each other, if they have the same number in column B.
Example
a 1
b 1
c 1
d 2
e 2
f 2
should end up as:
a b
a c
b c
d e
d f
e f
(the same number for a name means there is an interaction between the names - I want all interactions in the final two columns)
Any help to get this in a macro would be appreciated.
cheers
Last edited: