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: