Hi Eveyone,

I have data organised in the following way:

Title Units Customer
Title A 1 Customer 1
Title B 1 Customer 2
Title C 1 Customer 1
Title A 1 Customer 3
Title C 1 Customer 2
Title B 1 Customer 1
Title B 1 Customer 3

What I'm trying to do is sort the data so that we can show what each customer bought, so that using the (awesome) gephi software I can map the relationships between any two products. I can use pivot tables to work out who bought what but what I can't do is sort the data in the way I need to.

I need to get to the following layout:

Title Title 2 Weight
Title A Title B 2
Title A Title C 1
Title B Title C 1

this shows that 2 customers bought bought A&B, 1 bought A&C and 1 bought B&C. Its fairly easy to do manually for a few products, but a time consuming nightmare once the numbers and possible relationships increase.

What I could do with is an automated way of producing the second graph from the information in the first... any help will be greatly appreciated.


Many thanks,
Mark